I'm trying to solve an issue with counting blanks and/or non blanks in my excel document but knowing I need a variable range.

Here is the situation.

I want to count the number of blanks, then the number of non-blanks in Column B for as many rows as I have in Column A with a value. For example, Column A is guaranteed to have a value as it is an ID field and I want to know field completeness for Columns B, C, D, and E but knowing that my number of rows will change as the file is updated over time. So week one I might have 10 rows then week 3 30 rows. Instead of having to make changes to the formula or updating a field that would indicate my number of rows, I just want the formula to know that Column A will have the number rows to count.

Hope that makes sense.

Thanks!