Thread: N + 1
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default N + 1

Hi Eric,

Is your n value the n in a statistical analysis range.
If that is the case you could use =COUNT(A:A)+1
or if you need to limit the length of the range
use =COUNT(A1:A50)+1 or whatever.

HTH
Martin