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:p$65536"))))

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

Can any one help/
--
gibz