View Single Post
  #1   Report Post  
Jason
 
Posts: n/a
Default 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