Sum function to increase by one

[wjb1976]

Hi

I have a sheet which I use for orders and have 25 on the sheet each A4 size. The order number looks similar to 12345/2016/ABC/001 and would like the 001 to increase by 1 on each sheet but when I put in the basic formula of =SUM(C4+1) this doesn't work could anyone please provide a different one please?

Thanks

Will

[jeffreybrown]

Hi Will,

If I understand your picture/layout correctly, how about in C4 and drag down...

="12345/2016/ABC/"&TEXT(ROW()-3,"000")

[Pete_UK]

You could do something like this:

=LEFT(C4,15) & TEXT(RIGHT(C4,3)+1,"000")

Hope this helps.

Pete

[wjb1976]

Worked great

Thanks

[jeffreybrown]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.