Thread: WHETHER TO USE COUNTIF, SUMIF or SUMPRODUCT
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default WHETHER TO USE COUNTIF, SUMIF or SUMPRODUCT
You were quite close:

=SUMPRODUCT((F2:F1308="JET")*(MONTH(G2:G1308)=4))

--
Gary''s Student - gsnu200845
Reply With QuoteReply With Quote