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...
SergeiBaklan
May 19, 2024Diamond Contributor
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.
- KazMcCoy_2010May 19, 2024Copper ContributorThank you very much
- SergeiBaklanMay 20, 2024Diamond Contributor
KazMcCoy_2010 , you are welcome