EXCEL -- formula for SUMIF

  Dick9 08:10 23 Feb 05
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 05

this is a duplicate. I am sorry.

please erase.

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…