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(B2>1,J2>3)

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

=sumif(K2:K99,TRUE,B2:B99)


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

Regards,

Simsy

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

Elsewhere on IDG sites

Xiaomi Mi A3 Release Date, Price & Specification Rumours

Kristof Davos on how he designed this summer's must-have watch

Best Apple Deals of Amazon Prime Day 2019

Les 12 trucs et astuces Facebook Messenger à connaître