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??