 |
See three formulas for counting blanks or Not Started (OR ... Posted by: ExcelIsFun
Video duration: 369 seconds See three formulas for counting blanks or Not Started (OR criteria): 1. COUNTIF + COUNTIF 2. SUMPRODUCT 3. SUM COUNTIF with array constant criteria Download file: http://flightline.hi ghline.edu/mgirvin/E xcelIsFun.htm Cool Formula From Aladin at Mr Excel Message Board Related: excel, 2007, 2010, or, criteria, counting, sumproduct, array, syntax, for, countif, function, formula, functions, mike, gel, excelisfun, girvin, highline, community, college, vlookup, if, aladin, mr, message, board Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 676: Defined Name Dynamic Range Formula (column number varies) INDEX Function Posted by: ExcelIsFun
Video duration: 330 seconds See how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names). Download file: http://flightline.hi ghline.edu/mgirvin/E xcelIsFun.htm Related: excel, 2007, 2010, defined, name, dynamic, range, formula, column, number, varies, index, function, match, functions, mike, gel, excelisfun, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formula Posted by: ExcelIsFun
Video duration: 505 seconds See a great array formula from pgc01 and Aladin at the Mr Excel Message Board that will average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE. Download file: http://flightline.hi ghline.edu/mgirvin/E xcelIsFun.htm Related: excel, 2007, 2010, average, last, scores, mr, message, board, array, formula, mike, gel, excelisfun, girvin, highline, community, college, functions, if, row, countif, min, large, pgc01, and, aladin Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 678: SUM only Values After Deadline Dynamic Range using INDEX Function. Posted by: ExcelIsFun
Video duration: 368 seconds See how SUM only the Values After the Deadline using a Dynamic Range formula using INDEX Function. Also see a SUMPRODUCT function method. Download file: http://flightline.hi ghline.edu/mgirvin/E xcelIsFun.htm Related: excel, 2007, 2010, sum, only, values, after, deadline, dynamic, range, using, index, function, mike, gel, excelisfun, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 679: Adding Yearly Totals From Monthly Data - Date Formatting Trouble (2 Examples) Posted by: ExcelIsFun
Video duration: 435 seconds See 2 examples of how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions. Use the ampersand to join comparative operators to value in cells to create criteria. Download file: http://flightline.hi ghline.edu/mgirvin/E xcelIsFun.htm Related: excel, 2007, 2010, summarize, yearly, totals, from, monthly, when, there, year, criteria, is, entered, as, serial, date, mike, gel, excelisfun, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 680: Add A Scenario Button To Toolbar or Ribbon Excel 2010 Posted by: ExcelIsFun
Video duration: 298 seconds See how to Add A Scenario Button To Toolbar or Ribbon in Excel 2010. Download file: http://flightline.hi ghline.edu/mgirvin/E xcelIsFun.htm Related: excel, 2007, 2010, mike, gel, excelisfun, girvin, highline, community, college, see, how, to, add, scenario, button, toolbar, or, ribbon, in Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 681: Find Smallest Number That Is Greater Than Zero Array Formula Posted by: ExcelIsFun
Video duration: 110 seconds See how to use the MIN and IF functions to find smallest number that is greater than zero in an array formula. Download file: http://flightline.hi ghline.edu/mgirvin/E xcelIsFun.htm Related: excel, 2007, 2010, find, smallest, number, that, is, greater, than, zero, array, formula, mike, gel, excelisfun, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 682: Averaging Times Entered As Text (3 Examples) Array Formula Posted by: ExcelIsFun
Video duration: 382 seconds See three methods to averaged times values that were exported from a database as text values instead of number values: 1) AVERAGE and IF array formula 2) Text to Columns feature 3) AVERAGE, IF and TRIM function array formula Download file: http://flightline.hi ghline.edu/mgirvin/E xcelIsFun.htm Related: excel, 2007, 2010, averaging, times, entered, as, text, array, formula, average, if, trim, function, functions, mike, gel, excelisfun, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula Posted by: ExcelIsFun
Video duration: 490 seconds See how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula. Link for file: http://flightline.hi ghline.edu/mgirvin/E xcelIsFun.htm Related: excel, 2010, aggregate, function, small, array, formula, mike, gel, excelisfun, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel 2010 Magic Trick 665: AGGREGATE function Ignores Filtered Values When Making Calculations Posted by: ExcelIsFun
Video duration: 253 seconds See how to use the AGGREGATE function to make calculations on filtered data. SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested Subtotal or AGGREGATE functions. Download files: http://flightline.hi ghline.edu/mgirvin/E xcelIsFun.htm Related: excel, 2007, 2010, aggregate, function, ignores, filtered, values, when, making, calculations, excelisfun, mike, gel, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel 2010 Magic Trick 669: AGGREGATE function Can Not Handle 3-D Cell References Posted by: ExcelIsFun
Video duration: 103 seconds See that the AGGREGATE function cannot handle 3-D cell references. Download files: http://flightline.hi ghline.edu/mgirvin/E xcelIsFun.htm Related: excel, 2007, 2010, see, that, the, aggregate, function, cannot, handle, 3-d, cell, references, excelisfun, mike, gel, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
![Kid Copies Big Brother\](http://i.ytimg.com/vi/XsRnXUPZm1I/2.jpg "Kid Copies Big Brother\") |
Kid Copies Big Brother's YouTube Video of Falling Off Skateboard. Life Imitates Art. Posted by: ExcelIsFun
Video duration: 12 seconds Little Brother pretends to fall off skateboard just like his Big brother's YouTube Video. Related: mike, isaac, girvin, dennis, big, ho, little, brother, pretends, to, fall, off, skateboard, just, like, his, brothers, youtube, video, kid, digs, up, grass, with, toy, diggers, install, drainage, pipes, tonka, dump, truck, front, end, loader, excavator, bull, dozer Display Video Comments | Hide Video Comments | Add Comment |
 |
Kid Digs Up Grass With Toy Diggers To Install Grainage Pipes Posted by: ExcelIsFun
Video duration: 65 seconds Kid plays with toy diggers (Tonka Dump Truck, Front End Loader, Excavator, Bull Dozer) and digs up lawn and plans to install pipes all the way to the city. Related: mike, isaac, girvin, kid, digs, up, grass, with, toy, diggers, to, install, drainage, pipes, tonka, dump, truck, front, end, loader, excavator, bull, dozer Display Video Comments | Hide Video Comments | Add Comment |
 |
Kid Adds Drainage Pipe To Puddle While Playing With Toy Diggers Posted by: ExcelIsFun
Video duration: 183 seconds Kid Adds Drainage Pipe To Puddle While Playing With Toy Diggers Related: mike, isaac, girvin, kid, digs, toy, diggers, tonka, dump, truck, front, end, loader, excavator, bull, dozer, adds, drainage, pipe, to, puddle, while, playing, with Display Video Comments | Hide Video Comments | Add Comment |
Latest comments made on this video: