Microsoft Word 2000 Tables

[Neo]

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.

 

[macropod]

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/showthreaded.pl?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