Needing Formula

  • Thread starter Thread starter Tara
  • Start date Start date
T

Tara

I need to do a count if formula all I want it to do is
look up and count the numbers in a row that are >=100 but
<=800 for some reason it will not do this can someone help
me please.
 
Not elegant but it works
=COUNTIF(A1:A12,">=100")-COUNTIF(A1:A12,">800")
counts all greater than or equal to 100 and subtracts those greater than 800

Dan E
 
=COUNT(A10:H10)-COUNTIF(A10:H10,">800")-COUNTIF(A10:H10,"<100")

Vaya con Dios,
Chuck, CABGx3
 
Thomas said:
=SUM(COUNTIF(A1:A100,{">99","<801","<>"})*{1,1,-1}) ....
Click to expand...

The OP doesn't state that all numbers would be integers, so >99 IS NOT THE
SAME AS >=100. Ditto for <801.
 
Back
Top