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

Apple unveils first ‘pro’ iPhone 11 Pro and 11 Pro Max

InDesign at 20: how Adobe beat Quark to become the graphic design tool of choice

iPhone 11 Pro confirmed: Release date, price & specs

Les meilleures montres connectées (2019)