Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Blank page" is not blank. It contains text written weeks ago. | Microsoft Word Help | |||
Change Line Count to not count blank lines | Microsoft Word Help | |||
Blank Document-Template-Help!!! | Microsoft Word Help | |||
how can I use autosum in a WORD table with blank cells | Tables | |||
Why do I get a large blank space within my Word table? | Tables |