fuberator 13 Posted December 31, 2020 Hi What is the syntax for summing a bunch of cells? Say I have numbers in B3, H4 and J8 for example. I can't do =SUM(B3+H4+J8), so what is the correct way? Thank you Quote Share this post Link to post
Pat Stanford 1,528 Posted December 31, 2020 If you just want a few cells you don't need the sum you can just add them up: =B3+H4+J8 If you have a larger range you can specify the range by using two periods between the beginning and end of the range plus a Sum: =SUM(A3..D3) If you have a discontinuous (or continuous) range you can also use a comma as a separator in a Sum: =SUM(B3, H4, J8) Or you can combine the two styles: =SUM(A3..D3, H8) HTH 2 Quote Share this post Link to post