Exclude specific cell from entire column

[Guest]

Is it possible to exclude the column header from an entire column range, so
that it is not included a COUNTA range?

 

[Guest]

This may seem overly simple, but:

Just subtract 1 from the formula
Example:

A1: =COUNTA(B1:B1000)-1
Counts all non-blank cells in B1:B1000, then subtracts 1 for the column
header.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Guest]

=IF(LEN(A1)>0,COUNTA(A:A)-1,COUNTA(A:A))

Vaya con Dios,
Chuck, CABGx3