Using Sumproduct with multiple Criteria

[Mark Jackson]

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'!D31128)=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.

 

[Bob Phillips]

=SUMPRODUCT(--(MONTH('Sheet 1'!D31128)=2),--('Sheet1'!A3:A1128="some
value"),'Sheet 1'!L3:L1128)

etc.