Excel: Sumif function with two sets of criteria? Can it be done?

[Steelfan]

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

 

[Don Guillett]

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

 

[Mike H]

Hi,

Here's one way

=SUMPRODUCT((A1:A100=D1)*(B1:B100>=D2)*(B1:B100<=D3)*(C1:C100))

Where
D1= organisation name
D2= date of 1st day of the month to sum
D3 =date of last day of month to sum


Mike