View Single Post
  #2   Report Post  
macropod
 
Posts: n/a
Default

Hi Bradley,

Word's 'Above', 'Below', 'Right' and 'Left' field expressions are quirky at
the best of times - see 'Referencing Adjacent Cells In A Row Or Column' in
the Word document at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
(url all one line)

Having said that, you can't reliably avoid counting empty/blank cells with
{=Count(Below)}. A possible workaround, if you're counting cells with '1' in
them (or another non-zero numeric constant), might be to use something based
on {=Sum(Below)}.

Cheers


"Bradley C. Hammerstrom" bhammerstrom @ NOTTYSPAMrhadcock.com wrote in
message ...
The field code {=Count(Below)} works for me, but I want to skip blank

cells
in the column. How?




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004