Sumif with two criterias

[Guest]

I have mutiple sheets of information for which i want to sum values in column
p if columns c & d meet specified criteria.

The formula i have at present is

=(SUMPRODUCT(SUMIF(INDIRECT("'"&$AE$11:$AE$26&"'!$d$9:$d$65536"),$A11,INDIRECT("'"&$AE$11:$AE$26&"'!p$9$65536"))))

This works for one set of criteria but i don't know how to incorprate the
second.

Can any one help/

 

[Guest]

What are your criteria for columns C and D and I can assist.

 

[Don Guillett]

perhaps a simpler version
=sumproduct((c2:c22="joe")*(d2:d22=35)*p222)

 

[Guest]

Hi,

Column c is a number 2,3,4 etc and column d is text (i.e TP010)

Don, your formula works fine on a single sheet but i have approx 35 sheet
hence why the sheets are named in a specifed range.

Thanks for your help.