Posted to microsoft.public.excel.misc

franky

external usenet poster

Posts: 8

The copy down function for autosum gives wrong answers

It shows the first formula answer all belows which are not correct.

But the formula itself is correct.

Example

=SUM(D19:G19) =1125
=SUM(D20:G20) =1125 x
=SUM(D21:G21) =1125 x
=SUM(D22:G22) =1125 x

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Autosum Calculating Wrong	Kelly P	Excel Discussion (Misc queries)	5	January 15th 08 08:09 PM
My autosum total is incorrect - what is wrong?	Missing the obvious?	Excel Discussion (Misc queries)	1	September 3rd 06 04:38 AM
Wrong formula answers	Kevin G	Excel Discussion (Misc queries)	2	June 19th 06 08:04 AM
Recalculating Formula - Getting the wrong answers	skherzog	Excel Discussion (Misc queries)	2	June 29th 05 12:31 PM
Using formula one half of answers are wrong. I have checked my dat	jasmine	Excel Worksheet Functions	1	February 8th 05 04:07 PM

All times are GMT +1. The time now is 02:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us