Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Question about sumproduct
I understand the standard use of "SUMPRODUCT". But the following application
confused me. =SUMPRODUCT((A1:A10="Ford")*(B1:B10="June")) What this function does is to count the number of Fords sold in June. I have no idea how it works based on my understanding of basic use of the function. Any help will be appreciated. Jason |
#2
|
|||
|
|||
Bob Phillips' website can give you some insight:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html HTH Jason Atlanta, GA "Jason" wrote: I understand the standard use of "SUMPRODUCT". But the following application confused me. =SUMPRODUCT((A1:A10="Ford")*(B1:B10="June")) What this function does is to count the number of Fords sold in June. I have no idea how it works based on my understanding of basic use of the function. Any help will be appreciated. Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
sumproduct question | Excel Worksheet Functions | |||
SUMPRODUCT with date range question | Excel Discussion (Misc queries) | |||
SUMPRODUCT question | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |