Count subtotal lines

[Debbie]

I have a large spreadsheet that I subtotal. After
subtotalling, the subtotal amount appears in column D
leaving A-C as empty cells. I want to add a new column A
and then number JUST the subtotals 1 thru ? in ascending
order automatically in the new column A. I am working
with an IF statement so far =IF(isblank(B10),.... then
what? The first subtotal might be in row 5, the next in
row 11, etc. I can get the formula to enter #1 in each of
the subtotal rows but not 1,2,3,4,5 etc. Thank you in
advance for any advice you may have.

 

[Debra Dalgleish]

Enter the following formula in cell A2:

=IF(B2<>"","",MAX(A$1:A1)+1)

and copy down to the last row of the table.

 

[Debbie]

This does not number the subtotals 1,2,3,4...
It numbers 1,1,1,1,1... Thanks

 

[Debra Dalgleish]

Did you include the $ in the MAX function?

This does not number the subtotals 1,2,3,4...
It numbers 1,1,1,1,1... Thanks

 

[Debbie]

Yes I did.

-----Original Message-----
Did you include the $ in the MAX function?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.