View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
norman mellow norman mellow is offline
external usenet poster
 
Posts: 1
Default counting starting with a number other than 1

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?