How to make the numbering in column A skip any rows that have the Word "TOTAL" in column C but pick right up again in the next rows? At the same time can the rows with the word "TOTAL" in column C have their own numbering?
This should be achieved with a single formula and continue down the column AUTOMATICALLY with new appropriate numbers appearing down the column A when new rows are created / column C is updated.
I tried (using the answer given below) =IF(C1="TOTAL",COUNTIF(C$1:C1,"TOTAL"),ROW(A1)-COUNTIF(C$1:C1,"TOTAL")) it works but it does not automatically propagate in column A.
As an example if some rows contain "TOTAL" the column A would be:
Col A Col C 1 S 2 S 1 TOTAL 3 S 2 TOTAL 3 TOTAL 4 S 5 S 4 TOTAL