How do I add multiple numbers in a cell across a row? I successfully used this formula to add multiple numbers in a single cell SUM(SPLIT(C3,",")). But now I need to sum all the cells in the same row.

enter image description here

like this - where the total should be 185

enter image description here

1 Answer 1


Try this:



  1. We first JOIN everything together with a comma.
  2. SPLIT then puts each value into their own cells.
  3. Then finally, SUM Everything up.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.