| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why is the answer to my formula double what it should be?
I am creating a work sheet for my accounts. I have 12 months with different
values. At the end I want to add all the values to make one grand total. I have added them as follows (=SUM(B7:E7:B15:E15:B23:E23:B31:E31:B39:E39:B47:E4 7) The answer should be 120000-00 yet it says it is 240000-00. Why did this formula multiply the answer by two?? |
|
#2
|
|||
|
|||
|
Assume this is what you're trying to do?
=SUM(B7:E7,B15:E15,B23:E23,B31:E31,B39:E39,B47:E47 ) "Hayley B" wrote: I am creating a work sheet for my accounts. I have 12 months with different values. At the end I want to add all the values to make one grand total. I have added them as follows (=SUM(B7:E7:B15:E15:B23:E23:B31:E31:B39:E39:B47:E4 7) The answer should be 120000-00 yet it says it is 240000-00. Why did this formula multiply the answer by two?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula giving incorrect answer... | Excel Discussion (Misc queries) | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| How to solve a formula so that it returns actual answer if negati. | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
