Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I want to total up the numbers of split cells. I have an example as follows:
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.
use SUMPRODUCT which is able to sum numbers acting like text strings:
=SUMPRODUCT(SPLIT(A1, " "))
Required, but never shown