trying to modify formula for worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to to show a formula that will give me more than 90 days but less than 120 this is the formula I have now . Please someone help me. =SUM(IF($E$3:$E$599="19K10",IF($N$3:$N$599>=90,1,0),0))
Thanks Jeff
 
Try this formula instead, can be entered normally

=SUMPRODUCT(--($E$3:$E$599="19K10"),--($N$3:$N$599>=90),--($N$3:$N$599<=120)



--

Regards,

Peo Sjoblom

jeff said:
I am trying to to show a formula that will give me more than 90 days but
Click to expand...
less than 120 this is the formula I have now . Please someone help me.
=SUM(IF($E$3:$E$599="19K10",IF($N$3:$N$599>=90,1,0),0))Thanks Jeff
 
Back
Top