COUNTIF Issues count blank cells among existing data

well try using countblank instead of countif

This produces the same results. It does not specify what my last row of data actually is.

well can you upload a sample file for me to take a look at it

=COUNTIF('2999'!BU:BU,"")

Just try this formula once and see if it solves your problem

Sure here you go. My formulas are in the State Count sheet and under the UNKNOWN Area

That last formula produced the same results. I attached a sheet with my data in it for you to take a look.

See the attached sheet for solution.

What I have done is Column Named Inclusion I have used the following formula
=IF(BU2="",ROW(),"") which will give me all the row numbers where the cell is in Blank under the Column named State.

Then you can use either simple Min(Column Named Inclusion) or Max(Column Named Inclusion) to find the first and last blanks in Column named State. In case you want to the complete list the same has been provided in Column BW

Do let me know if you are satisfied with the solution.

Regards
Veejar

I modified your code a little bit

Please Login or Register  to view this content.

and this is what is displaying on my page

Please Login or Register  to view this content.

I did this so I could just count the rows that have a zero value in them. This seems to work just fine. Thanks for your help and pointing me in the right direction!

you ware welcome