View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Excel: Sumif function with two sets of criteria? Can it be done?

=sumproduct((a2:a22="orgA")*(month(b2:b22)=1)*c2:c 22)
or
=sumproduct(--(a2:a22="orgA"),--(month(b2:b22)=1),c2:c22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steelfan" wrote in message
...
I have a spread sheet that has different organizations in column A, Dates
in
Column B and payments received in C. I would like to do a calculation
that
will add all of organizations received payments with a calendar month. I
know I can do a sumif function by date and a sumif by organization name.
I
need to know if there is a way to do both. Thanks