How can I create auto numbering in column A?
I need the numbering in column A to skip any rows that have the Word "TOTAL" in column C but pick right up again in the next rows.
A TOTAL 1 A 763523 B TOTAL 2 D 765067 3 F 735273 E TOTAL 4 F 383763 5 C 933743 6 D 394863 G TOTAL 7 H 873674 1 Answer
In cell A2, just put 1; it's the first value and counting itself will give a circular reference warning.
As from cell A3, put the formula:
=IF(C3="TOTAL","",COUNTIF($A$1:A2,">0")+1) Basically, this will count all the values above 0 and add 1. Fill this formula down and you should be good :)
Or if you have only TOTAL and numbers in column C, then you can use the following in cell A2:
=IF(C2="TOTAL","",COUNT($C$1:C2)) 
