=SUMPRODUCT(--(A1:A1000="value1"),--(B1:B100=number))


--
HTH

Bob Phillips

wrote in message
oups.com...
I would like to create a =SUMIF equation that requires two variables to
be true (rather than just one) before it sums. Is this possible.

I have tried to use the =SUMIF(AND()) type equations but cannot get the
calculation to work. Any suggestions?