Referring to a COUNTed value
I'm a complete amateur when it comes to Excel so bear with me if my description isn't brilliant.
I have a table of results extracted from a database. The number of rows varies each week, say.
I use a COUNTA function on columnA (which is always populated) in order to find out how many rows the table has.
Then in subsequent columns, I want to count how many blank values I have. I tried doing this using the COUNTBLANK function, but I want to refer to the result of the COUNTA from columnA to define the range that this COUNTBLANK should consider.
Any advice gratefully received
Another way would be
but that will only count "real" blanks in column B, not so-called "formula blanks", i.e. "" returned by a formula
Say your counta formula is in ad2 and you want to count the blanks in col f (starting at f2)use following formula: :
Great - thanks guys!
Thanks for our suggestions. Worked great. I am a happy bunny again
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1