Difference resulting from Use of Auto-Sum and Sum() but Same Range?

[JMay]

I rec'd a file from within my office that includes 2507 rows of data with
column C containing numeric data (both positive and negative amounts). When
I highlight cell range C7:C2510 my auto-sum feature displays $293,301.14.
When I do a Sum(C7:C2510) I get $298,802,29 a difference of $5,501.15. At a
point if time there was a block of cells (within the group) that totaled
$5,501.15 that were positive but needed to be converted to negative so -1
was entered into a misc cell and Copied (Ctr-C) and the cells totaling the
$5,501.15 were highlighted and Edit-Special-Paste-Multiply OK was used to
change the sign; anyway I can't seem to figure our what is going on here.

One last thing to make it interesting.... If I highlight the entire
rowheaders from 7 through 2507 and then do a Format Unhide rows AND THEN
again do a Auto-Sum
my Auto-Sum then yeilds $298,802.29... Go Figure ???????????????

ANy help with {Confusion} this appreciated..

 

[ksgoodwin]

Maybe, just maybe, the autosum feature only sums the cells that are visible
and the sum function sums cells whether they are visible or not.

Ken

 

[Tom Ogilvy]

That would be true.

--
Regards,
Tom Ogilvy

Maybe, just maybe, the autosum feature only sums the cells that are visible
and the sum function sums cells whether they are visible or not.

Ken

At

 

[JMay]

Thanks Guys,,,
I solved by problem by inserting a temporary column and entered a sub-total
formula, then again using the Auto-sum on my orig Col C I compared the
accumulated Auto-Sum total to the sub-total downward until they ** disagreed
** only had to go down to row 93 to see that 94-144 were missing (the row
header only deemly indicating they were currently hidden). <<< This is the
only way I could figure to solve my problem.
Is there a better way??

As an accountant who believes in "balancing everything I get my hands on" -
it becomes a hellish thing when non-accounting type send you data where they
"somehow" thinks its no problem (to them) to just HIDE 51 rows of
**duplicate** numeric data...

Grrrrrrrrrrrrrrr......