[libreoffice-users] Re: Sum function isfiring in Calc

I use Calc to run a monthly (non-financial) spreadsheet for a small charity 
I'm secretary to -  a page per month, client cases on the vertical, various 
circumstantial details across the columns, SUM at the bottom of each column, 
the first of them a simple 'tally' column ( '1' entered for each caes to 
give a monthly total.)

Last month's page had 22 rows. When I came to sum up and report, I realised 
the tally total  wasn't in fact agreeing with the other totals. The same 
formula applies (they are all drag-copied from an original entry on a page 
some months back), but the SUM total in the Tally column is simply wrong - 
out by 1 to everything else.

Since it was such a small page, it was easily spotted and allowed for. In a 
larger page, it might have been a 2-coffee hold-up.

I report it more out of curiosity than anything else. Has anyone come across 
similar instances ?

Sincerely

Ian Graham
Wales
UK 


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted