You might want to test that cell A1 contains a number first:what if a1 is a formula that calculates a value
ex a1
if(b1="","",countif(b10:b2000,"s")
which equals 4567
its not giving the right answer
but if i manually type 4567 in it does
I cannot tell you if it will work on an Android phone or not, but this formula does work on an Excel worksheet (as long as your data always looks like shown... comma delimiter, number at the end of field with a space in front of it)...I want to know how to sum value of one cell without using Macro. Macro & VBA can not be used on Android devices.
Actually I am trying to maintain a excel sheet to manage and calculate my expenses.
For example as per above pic, I have few entries in B3 like Auto 50, Lunch 200, Dinne (sorry for spelling mistake) 150 so I want to add sum of 50+200+150 in C3. So C3 should show 400. Same for C4 where it should result as 800.
It should also calculate negative numbers. Like if cell have 50 & -20 so result should show 30.
It is possible to have any such formula without Macro so I can use that file on my Android phone as well?
That does not add up the whole numbers, rather, it adds up all of the individual digits.my contribution
=SUM(IFERROR(1*MID(D6,ROW($1:$99),1),))
press CTRL + SHIFT + ENTER