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

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


"Dn_" wrote:

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

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

Vaya con Dios,
Chuck, CABGx3



"Dn_" wrote:

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