Strange SUM function behavior

  • Thread starter Thread starter Always Care Adult Center
  • Start date Start date
A

Always Care Adult Center

I'm very confused right now. I have a very simple speadsheet with simple
functions in it to calculate attendance. I have the following function to
count monthly attendance for all people [=SUM(AH3:AH198)], which gives me a
total, and I have another function that adds up daily visits and I use the
following function to get another total [=SUM(C200:AG200)], which
theoretically should be the same, yet they aren't! I have no idea why this
is happening. What could be the problem?
 
Hi

if you'ld like to email me your spreadsheet direct (as long as its not over
2Mb) i'll be happy to look at it for you.

Cheers
JulieD
 
Always,

If any of the cells are text, SUM will ignore them. Select a cell and look
for either an apostrophe (it ain't no "single-quote") at the beginning in
the formula bar, or Format - Cells - Number (should not be set to "text").

Make sure calculation is set to Automatic (Tools - Options - Calculation).

You can select either range and look at the status bar (bottom), which will
give you a quick manual total.
 
Back
Top