Thread
:
Summing Cells with Text and Numbers
View Single Post
#
5
January 13th, 2010, 04:30 PM posted to microsoft.public.excel.worksheet.functions
Trevor Little[_2_]
external usenet poster
Posts: 5
Summing Cells with Text and Numbers
Thanks Bernard, This formula worked perfectly for me as well.
The same with the note I left on Mike's formula, I also had to use the
"value(..)" formula in order to have it it take the last part of the number
as a "number" value.
Thanks again.
"Bernard Liengme" wrote:
=SUMPRODUCT((LEFT(A1
1)="S")*(MID(A1
1,2,20)))
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"Trevor Little" Trevor
wrote in message
...
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)
.
Trevor Little[_2_]
View Public Profile
View message headers
Find all posts by Trevor Little[_2_]
Find all threads started by Trevor Little[_2_]