software

I wish to have rows automatically numbered in column quot;Aquot; according to the
content in column quot;Bquot;. If column quot;Bquot; has text or numbers in a cell I do not
want to number that row in column quot;Aquot;. If column quot;Bquot; is blank in a cell I
want to number that row in column quot;Aquot;. I found the following formula that
works the opposite of what I want quot;=IF(B1lt;gt;quot;quot;,COUNTA($B$1:B1)amp;quot;.quot;,quot;quot;)quot; .
What would the formula be if I wanted to numerically count the blank cells
in quot;Bquot; and skip the context cells in quot;Bquot;? Thanks for you consideration.
Regards
Hi!

Try this:

=IF(B1lt;gt;quot;quot;,quot;quot;,COUNTBLANK(B$1:B1))

Biff

quot;cox ng (1)quot; gt; wrote in message
news:FvSyf.114915$oG.107243@dukeread02...
gt;I wish to have rows automatically numbered in column quot;Aquot; according to the
gt;content in column quot;Bquot;. If column quot;Bquot; has text or numbers in a cell I do
gt;not want to number that row in column quot;Aquot;. If column quot;Bquot; is blank in a
gt;cell I want to number that row in column quot;Aquot;. I found the following
gt;formula that works the opposite of what I want
gt;quot;=IF(B1lt;gt;quot;quot;,COUNTA($B$1:B1)amp;quot;.quot;,quot;quot;)quot; . What would the formula be if I
gt;wanted to numerically count the blank cells in quot;Bquot; and skip the context
gt;cells in quot;Bquot;? Thanks for you consideration. Regards
gt;
gt;
This is precisely what I was looking for. Thank you for your time and
expertise.
Regards,
Gary

quot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; Try this:
gt;
gt; =IF(B1lt;gt;quot;quot;,quot;quot;,COUNTBLANK(B$1:B1))
gt;
gt; Biff
gt;
gt; quot;cox ng (1)quot; gt; wrote in message
gt; news:FvSyf.114915$oG.107243@dukeread02...
gt;gt;I wish to have rows automatically numbered in column quot;Aquot; according to the
gt;gt;content in column quot;Bquot;. If column quot;Bquot; has text or numbers in a cell I do
gt;gt;not want to number that row in column quot;Aquot;. If column quot;Bquot; is blank in a
gt;gt;cell I want to number that row in column quot;Aquot;. I found the following
gt;gt;formula that works the opposite of what I want
gt;gt;quot;=IF(B1lt;gt;quot;quot;,COUNTA($B$1:B1)amp;quot;.quot;,quot;quot;)quot; . What would the formula be if I
gt;gt;wanted to numerically count the blank cells in quot;Bquot; and skip the context
gt;gt;cells in quot;Bquot;? Thanks for you consideration. Regards
gt;gt;
gt;gt;
gt;
gt;