HOW TO RESTART COUNT FORMULA
 

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?

HOW TO RESTART COUNT FORMULA
 

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

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

And copy it down.

Regards,
Fred.

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

HOW TO RESTART COUNT FORMULA
 

Ok, I got it straightened out. You started me in the right direction. Thank
you!

"tgcali" wrote:

I tried your suggestion, but I got an error. Thanks for the assistance though.

"akphidelt" wrote:

Try this... pretend the data starts in A1 and you type in 1 in A1

So in A2 put the formula

=IF(A1="RESTART",2,A1+1)

The only problem with this is that when you manually type in RESTART it
erases the formula from that cell. This could or could not be a problem for
you but it does automatically restart the count when you type it in.

"tgcali" wrote:

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?

HOW TO RESTART COUNT FORMULA
 

I tried your suggestion, but I got an error. Thanks for the assistance though.

"akphidelt" wrote:

Try this... pretend the data starts in A1 and you type in 1 in A1

So in A2 put the formula

=IF(A1="RESTART",2,A1+1)

The only problem with this is that when you manually type in RESTART it
erases the formula from that cell. This could or could not be a problem for
you but it does automatically restart the count when you type it in.

"tgcali" wrote:

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?