Forum Discussion
KazMcCoy_2010
May 19, 2024Copper Contributor
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:D1...
dscheikey
May 19, 2024Bronze Contributor
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)