Forum Discussion

KazMcCoy_2010's avatar
KazMcCoy_2010
Copper Contributor
May 19, 2024

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...
Formulas and Functions
leecol102's avatar
leecol102
Copper Contributor
May 19, 2024

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 https://freecineapp.com.br/ and developed interest in this.

Resources