Using Sumproduct with multiple Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am currently using Sumproduct to sum totals based on a particular month.
I want to add ad extra criteria to this formula so it will only total based
on what month and the other criteria. Here is what I am currently using.

=SUMPRODUCT(--(MONTH('Sheet 1'!D3:D1128)=2),'Sheet 1'!L3:L1128)

This works just fine. What do I need to do to add the second criteria?

Thanks in advance for your help.
 
=SUMPRODUCT(--(MONTH('Sheet 1'!D3:D1128)=2),--('Sheet1'!A3:A1128="some
value"),'Sheet 1'!L3:L1128)

etc.
 
Back
Top