Needing Formula

[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.

 

[Dan E]

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

 

[Thomas]

another approach:
=SUM(COUNTIF(A1:A100,{">99","<801","<>"})*{1,1,-1})

 

[Lance]

or
=SUM(COUNTIF(A1:A100,{">99",">800"})*{1,-1})
Nice formula Thomas

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[Harlan Grove]

=SUM(COUNTIF(A1:A100,{">99","<801","<>"})*{1,1,-1}) ....

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