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...
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!
