Thanks a lot Mike, the formula worked perfectly. How does the "Len(x:x)"
Formula work? is it just the leftovers of the text?
(Just as one addition, I found that it wouldn't quite work for me until I
used the "Value(...)" formula in front of the number I wanted to use.)
Thanks again.
"Mike H" wrote:
Trevor,
With your 'numbers in a1 - d1 try this
=SUMPRODUCT((LEFT(A11,1)="S")*(RIGHT(A11,LEN(A 11)-1)))
Mike
"Trevor Little" wrote:
Is it possible to use the Sumif function to add numbers with a specific
designator in front of it?
Eg.
A row contains strings like: S8, S10, V5, S5
Is there a formula that can total the S's? (Total would be 23)