counting starting with a number other than 1

N

norman mellow

I am creating automatically generated tracking numbers for groups of data by
using the following formula: =IF('Sheet !'!A1 = 0,COUNT($A$6:A6)+1, " ") ( in
these groups of data the header row is 0 in the A column, if that ake sense).
What I need to do now is make the count start at a number other than 1, say,
2000. What do I need to add to the forumla to accomplish that?
 
K

KC Rippstein hotmail com>

Instead of +1 as you've shown here, do +2001.
=IF('Sheet !'!A1 = 0,COUNT($A$6:A6)+1, " ")
becomes
=IF('Sheet !'!A1 = 0,COUNT($A$6:A6)+2001, " ")
 
Top