I don't think...

  Simsy 09:06 23 Feb 2005

you can have 2 conditions in a "sumif"

What you can do however, is have an additional colum, that has the conditions in, giving a true/false answer, and have a sumif reffering to this range...

eg, in your example (I'll use row K as the extra row);

have in K2 the formula;


and copy this down to K99.

For each row the at both conditions are met the value in K will be "TRUE"

So now you can make your sumif formula


I hope this helps. My apologies if there is a simpler way to do it!



This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Huawei Mate 30 Pro Review: Hands-on

Fred Deakin on creating the artwork for his sci-fi rock opera The Lasters

Best iOS 13 features: What does iOS 13 do

Les meilleures enceintes connectées avec écran tactile (2019)