EXCEL -- formula for SUMIF

  Dick9 08:10 23 Feb 2005
Locked

I want to sum up the numbers in column J conditionally if BOTH of 2 separate conditions are met.

This formula works ; to wit,
SUMIF(b2:b99,>1,j2:j99)

But how should one put in "and" so that it also includes f2:f99, >3 , j2:j99

The sumnation would then be of fewer cells than either condition on its own; and the count would also be fewer.

I use windows 98.

  Dick9 08:13 23 Feb 2005

this is a duplicate. I am sorry.

please erase.

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017