Question about sumproduct

J

Jason

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
 
Top