Count Values in Excel

[miletracker]

I HAVE A LIST OF VALUE 1100 TO 1500 I NEED TO COUNT ALL VALUES BETWEEN 1200 AND 1299
also need to count how many rows in a list contain a formula
MILETRACKER

 

[bluedragon2]

for the count number part:

=COUNT(A:A)-COUNTIF(A:A,&quot;<1200&quot-COUNTIF(A:A,&quot;>1299&quot

substitute A:A with your list.

for the counting of miletracker, need more information.


Blue

If I wasn't Blue, I would just be a Dragon...

 

[miletracker]

I am sorry for not being clear I need to count how many rows of a list contain formulas without checking that sheet
rows could be blank or contain data

Thanks for the reply

 

[bluedragon2]

The only formula that will tell you if there is something there or not is ISBLANK(). ISBLANK() will retrun a false if there is anything in the cell (even a formula that shows nothing). So, use ISBLANK to determine if your cells are blank or not, then count the output.



Blue

If I wasn't Blue, I would just be a Dragon...