sum text & numbers

[grizzly6969]

I have a spredsheet
A27 = V8
B27 = V12
C27 = V6
etc. etc.
I would like X27 to equal sum of numbers only , Letter is always "V"
so in this case X27 = 26

 

[JoeU2004]

I would like X27 to equal sum of numbers only , Letter is always "V"
so in this case X27 = 26

=SUMPRODUCT(--MID(A27:C27,2,10))

Works for numbers (after "V") up to 10 digits; increase as needed.

Works for one contiguous range. Add MID() terms as needed for additional
ranges, e.g.:

=SUMPRODUCT(MID(A27:C27,2,10)+MID(A28:C28,2,10)+MID(D29,2,10))

Simply add MID terms if all cells are discontiguous, e.g.:

=MID(A27,2,10)+MID(B28,2,10)+MID(C29,2,10)


----- original message -----

 

[Lars-Åke Aspelin]

I have a spredsheet
A27 = V8
B27 = V12
C27 = V6
etc. etc.
I would like X27 to equal sum of numbers only , Letter is always "V"
so in this case X27 = 26

Try this formula:

=SUMPRODUCT(0+SUBSTITUTE(A27:C27,"V",""))

Hope this helps / Lars-Åke