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

  • Thread starter Thread starter 48160
  • Start date Start date
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.
 
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i write a sentence in a cell? 1
Look Up and Count 4
HOW TO COUNT VALUES BASED ON MULTIPLE CRITERIA IN EXCEL? 2
Count Formula 1
formula to count formatted result value 1
counting cells that contain a date 3
help needed. what kind of formula I need to use that I would.... 2
Excell formula help 2

Back
Top