Dear All,
I have list in column A and need to make countA subtotal by function in column B. If there is a blank row in column A, then the subtotal will re-start as in table.
Need help for do it in Excel by function.
Thank in advance
Omega Boost
Dear All,
I have list in column A and need to make countA subtotal by function in column B. If there is a blank row in column A, then the subtotal will re-start as in table.
Need help for do it in Excel by function.
Thank in advance
Omega Boost
Maybe this, in B2, copied down:
=IF(A2="",0,B1+1)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
or... if you have a TEXT header in B1, then use:
=IF(A2="",0,IF(ISTEXT(B1),0,B1)+1)
Dear Glenn,
Thank you for the respond but what i need is the function with subtotal.
Does my formula give you the correct result?
Why is it important to use SUBTOTAL?
Is this homework, or coursework?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks