3

This might get a little messy, but bear with me.

Say Column C has 10 cells. Each cell has several values separated by commas;C2 may have "1, 10, 9, 80", C3 may have "2, 25, 90, 5", etc. I want to sum the entire column somewhere.

Currently, I can sum a single cell with commas with the following formula; =ARRAYFORMULA(IFERROR(SUM(SPLIT(C1,",")))), but I would like to sum all of the cells in that row.

Is this possible?

Here is a copy with columns C-F needing to be separately summed:

https://docs.google.com/spreadsheets/d/1-iCEzZenqWzauIF6_brRlQgHmGmc8eAObXKhJwI8k5U/edit?usp=sharing

2 Answers 2

3

Just apply the formula to the range:

=ARRAYFORMULA(IFERROR(SUM(SPLIT(C1:C3,","))))
1
  • This works fine.
    – Rubén
    May 9, 2018 at 15:32
0

I used this:

=SUM(SPLIT(TEXTJOIN(", ",TRUE,C1:C10),", "))

Hope it can help you.

1
  • This works fine.
    – Rubén
    May 9, 2018 at 15:32

Your Answer

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

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