Thread
:
Summing Cells with Text and Numbers
View Single Post
#
9
January 14th, 2010, 01:15 PM posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
external usenet poster
Posts: 516
Summing Cells with Text and Numbers
=SUMPRODUCT((LEFT(A1
1)="S")*VALUE((MID(A1
1,2,2 0))))
VALUE is needed if there are any empty cells
Bernard
"Trevor Little" wrote in message
...
Hi Bernard,
I just came across one problem with the formula that I haven't been able
to
figure out. It doesn't seem to work, if 1 of the cells in the array is
blank... is there a way of putting in a condition where it ignores the
blank
cells?
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)
.
Bernard Liengme
View Public Profile
View message headers
Find all posts by Bernard Liengme
Find all threads started by Bernard Liengme