EXCEL -- formula for SUMIF

  Dick9 08:10 23 Feb 05

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

This formula works ; to wit,

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.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant