Thread: Summing Fields with Multiple Criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Summing Fields with Multiple Criteria
=SUMPRODUCT(IF(TEXT(A1:A100,"Mmmm")="January",1,0) ,IF(B1:B100="John
Smith,1,0))

HTH
Kostis Vezerides

Reply With QuoteReply With Quote