Forum Discussion
Excel Formula help needed
Hi, sorry a real beginner here trying to be better!! I want to add certain column's together but the formula adds the last column twice and I don't know why.
I am using this formula =SUM(D11:D14:D19) D19 has been calculated twice, can anyone advise please?
6 Replies
You should separate the ranges you want to sum with commas like this: =SUM(D11:D14, D19).
This way Excel will sum the values in D11 to D14, and then add the value in D19 without counting it twice. Excel is a good tool and I had please watching movies like the Accountant on Freecine app from freecineapp.com.br and developed interest in this.Thank you very much leecol102
As a comment,
=SUM( D11:D14:D19 )works the same way as
=SUM( D11:D19 ), i.e. sums all values in the cells from D11 to D19. It shall not to sum D19 twice.
- Thank you very much
KazMcCoy_2010 , you are welcome
You must separate individual cells from each other with a comma. Areas are separated with a colon. So you have used ranges but probably wanted cells.
=SUM(D11,D14,D19)
