I am trying to find a way of counting the number of non-blank cells in a word
table column. The table formula =COUNT(ABOVE) returns the total number of
cells regardless of what they contain.

If there is a way of excluding the cell on the table heading row then this
would be better still.

Can anyone help?

Regards,


Neo.

Hi Neo,

AFAIK, there's no reliable way of counting the number of rows in a table
using a formula field, let along the number of non-blank rows. The 'ABOVE'
and similar expressions need to be handled with particular caution. See my
Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
for a detailed explanation.

If you really need a count, you'll have to do it manually, or code a macro
to do it for you.

Cheers

--
macropod
[MVP - Microsoft Word]


"Neo" wrote in message
...
I am trying to find a way of counting the number of non-blank cells in a
word
table column. The table formula =COUNT(ABOVE) returns the total number of
cells regardless of what they contain.

If there is a way of excluding the cell on the table heading row then this
would be better still.

Can anyone help?

Regards,


Neo.