See methods for summing with criteria: specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values than are NOT equal to...
November 2010 Update: Visit: www.ExcelinaMinute.com for my new Excel video tutorials. "One minute videos for bite-sized learning!" Excel tutorial on the uses of the math...
Excel 2007 comes with several new functions, including SumIFs, AverageIFs, CountIFs, IFError, and more. I cover all of these new functions in detail in my...
SUMIFS blows SUMPRODUCT away when it comes to calculating Speed. See how the Excel 2007 formulas SUMIFS and COUNTIFS and AVERAGEIFS are much faster than...
See how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a Percentage Increase Formula. This is...