Hot Topics

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

Realme X50 Pro 5G confirmed: Release date, price & specs

How do you brand real estate for Generation Rent?

Best free iPhone apps

iPad et iPhone : comment installer Microsoft Office gratuitement ?