Excel Forum

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.