1

I want to total up the numbers of split cells. I have an example as follows:

1234
0000
5678

each number is in its own cell, I want to total it all up underneath to get 6912,
so 1234 + 0000 + 5678 = 6912 if this makes sense.

0
  • use SUMPRODUCT which is able to sum numbers acting like text strings:

    =SUMPRODUCT(SPLIT(A1, " "))

    0


    =SUMPRODUCT(A1:A3)

    0

| improve this answer | |
  • 1
    Cool thanks for that I will try it out – Peteh Jun 21 '19 at 23:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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