Forum Discussion
Sum help
Okay, I am trying to make a sheet to track PTO hours and add/sort them by the number of hours based on what kind of hours they are. Example, in one month, Suzy may have 3S, 5V, 7S, 5V, 5V. I am seeki...
I suggest you remove all the text from the numeric values.
Assuming you have 3 in cell A1 and 7 in cell A2
Then, you can do the following
=SUM(A1:A2)&"S"
That will return 10S
Assuming you have 3 in cell A1 and 7 in cell A2
Then, you can do the following
=SUM(A1:A2)&"S"
That will return 10S
Thanks for the response Abiola1 . Turns out I did some more digging and found that there is indeed a way with this formula: =SUMPRODUCT(--(LEFT(B5:AF5,1)="S"),IF(ISERROR(--RIGHT(B5:AF5,LEN(B5:AF5)-1)),0,--RIGHT(B5:AF5,LEN(B5:AF5)-1)))
The letter must come before the number, and to use the formula you must hit ctrl+alt+enter. It works too!
- Nice one 👍
