| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
The copy down function for autosum gives wrong answers
On Mon, 5 Jan 2009 14:57:00 -0800, franky
wrote: 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 What are the data you have in the cells and what are your expected outputs from these formulas? Lars-Åke |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
The copy down function for autosum gives wrong answers
"Lars-Ã…ke Aspelin" wrote: On Mon, 5 Jan 2009 14:57:00 -0800, franky wrote: 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 What are the data you have in the cells and what are your expected outputs from these formulas? Lars-Ã…ke Thank you for your prompt response, Lar-Ake I found the something wrong with the copy down function in the work wheet. They are just numbers and caculations |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
The copy down function for autosum gives wrong answers
Try setting calculation mode to Automatic.
ToolsOptionsCalculation. Gord Dibben MS Excel MVP On Mon, 5 Jan 2009 14:57:00 -0800, franky wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
The copy down function for autosum gives wrong answers
"Gord Dibben" wrote: Try setting calculation mode to Automatic. ToolsOptionsCalculation. Gord Dibben MS Excel MVP On Mon, 5 Jan 2009 14:57:00 -0800, franky wrote: 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 Thank you very much. I get it. Have a nice day !!! Franky |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autosum Calculating Wrong | Excel Discussion (Misc queries) | |||
| My autosum total is incorrect - what is wrong? | Excel Discussion (Misc queries) | |||
| Wrong formula answers | Excel Discussion (Misc queries) | |||
| Recalculating Formula - Getting the wrong answers | Excel Discussion (Misc queries) | |||
| Using formula one half of answers are wrong. I have checked my dat | Excel Worksheet Functions | |||
Linear Mode
