How do I write a formula in Exel that will keep a running count?

4

48160

I have created a mail log at work on Exel, but the trouble I'm is each I make
a new entry I to continue to add a item number in colume A (1, 2, 3.....). If
anyone can answer this question I would greatly appreciative.
 
D

David Biddulph

If you are entering your data in column B, for example, then in A1 you could
use =IF(B1="","",ROW()) and copy down the column.
 
F

FSt1

hi
in a2 enter..
=A1+1
then copy down.
to hide the formula(if you want) until entries are made in column b....
=if(b2="","",A1+1)

Regards
FSt1
 
T

T. Valko

One way...

Assuming A1 and B1 are column headers and B2 is your first entry.

Enter this formula in A2 and copy down as needed to allow for future
entries:

=IF(B2="","",N(OFFSET(A2,-1,,))+1)
 
Top