Don't you think he milked it?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"M.A. Clark" wrote in message
...

Sorry for all the guff you took on-line over your helping me with this
issue, it really did fix the problem and is sincerely appreciated.

-Mac


"T. Valko" wrote:

One way:

Try this array formula**:

=SUM(IF(LEFT(A1:A10)="S",MID(A1:A10,2,255)+0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"M.A. Clark" <M.A. wrote in message
...
Perhaps this feature is not supported in Excel but here goes.... I
have
data
that represents Sick Time, Holiday Time, etc in single cells on a
spreadsheet. For example, to represent a Sick day of 5 hours, a single
cell
would show S5. What I am attempting to do is 1. Identify which cells
in a
single column have an S, 2. Once identified, add the value next to S to
the
sum of all Sick time. To get the count of S I used
Countif(B5:B370,"S*")
This works. But I have tried all kinds of combinations to Sum the
resulting
numbers. This is a group common spreadsheet so separating the data to
multiple cells is a bit of a fight. Any help would be appreciated.