HOW TO RESTART COUNT FORMULA

  • Thread starter Thread starter tgcali
  • Start date Start date
T

tgcali

Hello,

I need to have 24 rows that count from 1 on down in column A.
1
2
3, etc.

If on any given row RESTART is entered, I need the count to start over on
the next row from two to the end of the list. In other words RESTART would be
substituted for the number 1 and the count would continue:

RESTART
2
3, etc.

Can I do this?
 
Where is RESTART entered? Assuming it's column A, try something like:

=if(a2="RESTART",2,a2+1)

And copy it down.

Regards,
Fred.
 
Ok, I got it straightened out. You started me in the right direction. Thank
you!
 
I tried your suggestion, but I got an error. Thanks for the assistance though.
 
You must log in or register to reply here.

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

counting blank cells within two columns 2
Count Names 2
Count help with numbering Rows? 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
How to Populate Data from a table to another 0
Excel Formula - Count Dates from another Sheet 8
Help with Count formula 2
Microsoft Word 2017 VBA Troubleshooting Restart Numbering Macro 0

Back
Top