Excel 2002: How to add running numbers ?

[Mr. Low]

Dear Sir,

I have the following worksheet :

A B C D E
1 IV791667 5/31/2001 RT158674 1,000.00
2 IV791666 5/31/2001 RT158674 1,000.00
3 IV790692 5/28/2001 RT158674 500.00
4 1 TOTAL : 2,500.00
5 IV796284 6/24/2001 RT158836 3,609.40
6 2 TOTAL : 3,609.40
7 CN025037 7/28/2001 RT158465 26.10
8 RD864412 7/13/2001 RT158465 0.00
9 3 TOTAL : 26.10
10 CN025017 7/28/2001 RT158070 102.60
11 RD861084 6/29/2001 RT158070 0.00
12 4 TOTAL : 102.60
13 CN024979 7/28/2001 RT158063 17.55
14 RD86102 6/29/2001 RT158063 0.00
15 5 TOTAL : 17.55


May I Know what formula i must Input at cell A1 and copy down to get the
sequence numbering for each row which has the word “TOTAL: “ at column D ?


Thanks

Low

 

[Jon Peltier]

Enter this in A2 and drag it down:

=IF(D2="TOTAL :",MAX(A$1:A1)+1,"")

- Jon

 

[Max]

One way ..
In A1: =IF(D1="Total :",COUNTIF($D$11,"Total :"),"")
Copy down

 

[Teethless mama]

In A2: =IF(D2="Total :",COUNT($A$1:A1)+1,"")
copy down

 

[Mr. Low]

Hello Jon,

Many thanks for your formula.

It works perfectly well.


Kind Regards

Low

 

[Mr. Low]

Hello Max,

Many thanks for your formula.

It works perfectly well.


Kind Regards

Low

 

[Mr. Low]

Hello Madam,

Many thanks for your formula.

It works perfectly well.


Kind Regards

Low

 

[Mr. Low]

Hello Madam,

Thanks for your formula.

Low

 

[Max]

welcome, Low