hi,

use an array formula like

SUM(IF((FirstRangedName=FirstCriteria)*(SecondRang edName=SecondCriteris);RangeToSum;0))

Don't forget that * stands for AND , +for OR

Regards,

Nick

"Don Guillett" wrote in message ...
try
=sumproduct((P2:p200={a1,b1})*g2:g200)

--
Don Guillett
SalesAid Software

"Mike@Q" wrote in message
...
Hi

I am trying to sum cells that fulfil either criteria A or criteria B. I
have
tried =SUMIF(P:P,A1orB1,G:G). I can not simply add two SUMIF's together as
I
need to reduce the length of the overall formula.

Thanks for your help