Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
billfalls
 
Posts: n/a
Default Incorrect result from =count(above)

=count(above) gives a correct result when there is more than one item above
it in the column. However, if there is just one item the result is 0 (zero).

This small table has no empty rows, and I insert and delete rows as needed.
When I experimented by adding an empty row I got 2 as the (incorrect) result
as reported in the very helpful "Word Field Maths" document by macropod
mentioned elsewhere in this discussion group. No one seems to have reported
the error I describe above.
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod
 
Posts: n/a
Default Incorrect result from =count(above)

Hi billfalls,

This is more of the same bug with the count(above) function, which always
count all of the consecutive preceding rows until it encounters the last
such row with a number, then all consecutive preceding numbered rows until
it encounters a non-numeric row, and counts that too. If there are no
preceding rows with numbers, this means you get a count of all preceding
rows.

Cheers


"billfalls" wrote in message
...
=count(above) gives a correct result when there is more than one item

above
it in the column. However, if there is just one item the result is 0

(zero).

This small table has no empty rows, and I insert and delete rows as

needed.
When I experimented by adding an empty row I got 2 as the (incorrect)

result
as reported in the very helpful "Word Field Maths" document by macropod
mentioned elsewhere in this discussion group. No one seems to have

reported
the error I describe above.



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
format numbers as words 007djr Microsoft Word Help 3 February 23rd 06 10:40 AM
Convert numeric value into english word RKS Microsoft Word Help 1 August 25th 05 07:33 PM
CardText Field Switch JoyceA Mailmerge 2 June 18th 05 11:05 AM
Method for displaying dollar amount as written on bank check samandmonty Microsoft Word Help 5 May 11th 05 10:54 PM
How do I turn dollar amounts into words? Theresa Wright New Users 5 January 25th 05 11:28 AM


All times are GMT +1. The time now is 05:45 PM.

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

About Us

"It's about Microsoft Word"