Reply
 
Thread Tools Display Modes
  #1   Report Post  
Bradley C. Hammerstrom
 
Posts: n/a
Default Count below not including blank cells

W2000

A small table repeated many times in the document (i.e. copy and paste-able)
lists addresses in two columns.

The number of addresses in one column will always be less than the other,
leaving some number of blank cells.

I want a Count formula in both column headers. I'm using:
= Count(Below)
but this is also counting the blank cells at the bottom of the shorter
column.

Q: How can I count the items in the column below without including blank
cells?

PS. I cannot use a stated range, like = Count(a2,a9) because the table needs
to be easily duplicated without editing the formulas in the column headers.

Brad H.


  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi Bradley,

Q: How can I count the items in the column below without including blank
cells?

Word doesn't provide any functionality for this. theoretically, you could
embed Excel tables and use the CountA function in them. Other than that,
you'd need a macro...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
"Blank page" is not blank. It contains text written weeks ago. Kingfish Microsoft Word Help 3 January 7th 05 09:52 PM
Change Line Count to not count blank lines Carol Microsoft Word Help 4 November 27th 04 01:46 PM
Blank Document-Template-Help!!! Joe G Microsoft Word Help 1 November 26th 04 08:05 PM
how can I use autosum in a WORD table with blank cells Jennifer from DPI Tables 4 November 11th 04 07:30 AM
Why do I get a large blank space within my Word table? Todd F. Tables 1 November 4th 04 07:05 PM


All times are GMT +1. The time now is 06:52 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"