Thread: SUM if the conditions are met
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vass[_2_] Vass[_2_] is offline
external usenet poster
  
Posts: 4
Default SUM if the conditions are met

"Max" wrote in message
...
In D2:
=SUMPRODUCT((A2:A10=--"23 Oct 2007")*(C2:C10="X"),B2:B10)

How would that work when his data uses "10" for October?


Reply With QuoteReply With Quote