Excel Forum
Similar Content
How to use the Vlookup Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when you...
Get the Row or Column Number of a Cell in Excel
Tutorial: How to get the row or column number of the current cell or any other cell in Excel. This t...
RATE Function - Calculate an Interest Rate in Excel
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...

Highline Excel Class 37: SUMPRODUCT function

Topics for this video:
1)Learn about the basics of SUMPRODUCT
2)The SUMPRODUCT function multiplies arrays of the same size and then adds the products
3)See how to get SUMPRODUCT function to multiplies arrays of different sizes and then add the products
4)See how to use the SUMPRODUCT function, the TEXT function, Custom Number Formatting and double negatives to add with date and sales Rep conditions (criteria).
5)See count to count with date and sales Rep conditions (criteria)
6)See an easy way to deal with serial number dates when month and year criteria are not also serial number dates using the TEXT function and Custom Number Format
7)See that SUMIF cannot handle arrays, but SUMPRODUCT can handle arrays
8)See how putting a range in the value argument for the TEXT function creates an array.
9)Conditional adding (summing) more than 1 criteria adding
10)Conditional counting more than 1 criteria
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Got a Question? Ask it Here in the Forum.