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

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