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

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.

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

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.
--
David Biddulph

"48160" wrote in message
...
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.

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

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

"48160" wrote:

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.

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

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)

--
Biff
Microsoft Excel MVP


"48160" wrote in message
...
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.