How to Insert Numerical Values in a Google Sheet Cell and Find Their Sum

androidgoogle sheetsmobile

I use Google Sheets mobile(Android).
I have one column with dates, and anoter column where in each cell I want to input several numerical values that corespond in each date, and in a third column the sum of those numerical values ( actually I plan to do 50 pushups every day for 5 days in several sets in each days, but I dont know the number of the daily sets).
5 days 50 pushups

The problem is that when I input numbers in column B seperated by either commas or spaces, the sheet converts the numbers into a date.
For example when I insert in B2 5,5,2 it converts it in 5 5 2002
enter image description here

How can avoid this problem?
(maybe with something like an arraylist? )
And if there is solution to the above problem, is there any way to input in the C column the sum of those numbers?

I don't know the number of columns, each time the number of sets are different

Best Answer

you can try entering numbers in B column like:

  • '5,5,2

enter image description here

or

  • ="5,5,2"

enter image description here

or

  • =TEXT(; "5,5,2")

enter image description here

or

  • =T("5,5,2")

enter image description here

and then SUM it with a formula like:

=SUM(SPLIT(B247;",";1;0))

enter image description here

Related Topic