Google Sheets: Sum each digit in Cell to Double and Single Digit

[rbhapkar]

Requesting Excel formula help from Experts for adding all digits (including digits after decimal point) to a double digit figure & then to a single digit figure

For example :
High cell value is 1561.95; Outcome : 1+5+6+1+9+5 = 27 (two digit SUM in one cell) & 2+7 = 9 -> the two digits answer converted to a SINGLE digit in adjacent cell
Low Cell Value is 7277.65; Outcome : 7+2+7+7+6+5 = 34 (two digit sum in one cell) & 3+4 = 7 in adjacent cell (converted to SINGLE Digit total)

Attaching the Excel Sheet for reference

Please note:
A) Sample figures mentioned herein. Requesting help for

1) Col C values - to be converted to double digit in Col F & then to Single Digit in Col G (for HIGH value) and

2) Col D values - to be converted to double digit in Col H & then to Single Digit in Col I (for LOW Value)

B) Comments mentioned in col J (what I have tried to mention above)
C) Have mentioned the expected output in Col F, G, H & I (for reference please)

Thanking you in advance

Warm Regards-RB

[Ron Coderre]

Try these regular formulas, copied down:

Please Login or Register  to view this content.

Is that something you can work with?

[rbhapkar]

Dear Ron
Thanks a lot for the solution. It worked beautifully in Excel.
Just one problem, the same did not work in Google Excel Sheet. Any specific reason ?

Warm Regards-RB

Attachment 655162Attachment 655163

[AliGW]

You did not tell us this was about Google Sheets - there's an appropriate forum section for this, so I am moving your thread.

[FlameRetired]

Another way:

For the Highs
In F2

Please Login or Register  to view this content.

In G2

Please Login or Register  to view this content.

For the Lows use the same formulas with the Low cell references.

[rbhapkar]

Dear Ali
I want the details in excel only - but due to some problems in the backend software, am temporarily working in Google Docs.
Actually, this is the data from LIVE Stock markets and Google Docs doesn't work Real Time in all scrips and also there is a limitation on the number of hits/Refresh per day and hence using Google Docs as a stop gap arrangement
Anyways, thanks for update.
Request the link where this thread is shifted.

Warm Regards-RB

[AliGW]

The thread has been moved - you don't need a link (you are there already).

[rbhapkar]

Dear Flame
Thanks for revert. Heartily appreciate your prompt revert. Have got the solution in one of the earlier post (shown in the first table in the attached PNG File).
Tried your formula also - wherein something is not correct and the output is incorrect (as shown in the second table in the attached PNG file)
Attaching the screenshot - for your reference.


Thanks once again

Warm Regards-RB
Attachment 655166

[FlameRetired]

You are welcome.

PNG files (pictures) aren't usually much help. I just know the formulas work at my end. Without an actual workbook upload demonstrating the short-comings I can not advise or derive instruction myself. (Yeah. I learn from these threads, too. )

Anyway I have time on my hands this afternoon and I found this challenge intriguing. Here are some new formulas applied to your upload.

In F2:F5

Please Login or Register  to view this content.

I noticed that both Ron's and mine return 10 in cell G5. That's not what you wanted. This returns the desired 1. In G2:G5

Please Login or Register  to view this content.

In H2:H5

Please Login or Register  to view this content.

In I2:I5

Please Login or Register  to view this content.

[rbhapkar]

You are welcome.

PNG files (pictures) aren't usually much help. I just know the formulas work at my end. Without an actual workbook upload demonstrating the short-comings I can not advise or derive instruction myself. (Yeah. I learn from these threads, too. )

Anyway I have time on my hands this afternoon and I found this challenge intriguing. Here are some new formulas applied to your upload.

In F2:F5

Please Login or Register  to view this content.

I noticed that both Ron's and mine return 10 in cell G5. That's not what you wanted. This returns the desired 1. In G2:G5

Please Login or Register  to view this content.

In H2:H5

Please Login or Register  to view this content.

In I2:I5

Please Login or Register  to view this content.

Thanks a tonne Flame. Really appreciate you taking time to revert to my query

[rbhapkar]

Can someone help me with similar formula for Google Sheet please?
Above given reverts by Experts have resolved my Excel Requirement. But still fighting out for the same in Google Docs please

[rorya]

Just wrap the given formulas in =ARRAYFORMULA(...)