Sumif / Countif - Not certain - want to extract data from cell and

We'll just leave it that ... except when I want to make another point.

Calling him greenteeth is hardly grown-up is it?

Does being called a whining baby by some other unenlightened poster warrant
that silly level of response?

And finally, you make the response that could have been so effectively made
against TM's comments originally.

No I am out of here.

--
---
HTH

Bob


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



"T. Valko" wrote in message
...
We'll just leave it at that.

Well, maybe just one important point:

responding with ... a reasoned argument.

The last time I tried that with greenteeth all I got for my efforts was to
be called a "whinning baby".

And another important point, which is what that exchange was all about:
greenteeth's suggested correction to my formula will also fail if......

The point being: almost every formula will fail, if..... At what point
does dealing with improbable/impossible "if's" become inefficient
overkill?

I'm outta here!


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Well, you're entitled to your opinion/interpretation but I completely
disagree with it.

We'll just leave it at that.

--
Biff
Microsoft Excel MVP


"Bob Phillips" wrote in message
...
Okay, if you want it spelt out.

Teethless mama made a point, which regardless of what the OP had said,
was valid. Your response was curt and to my eyes, petulant. TM's
response was to explain in greater detail, I think he felt you didn't
understand what he was saying. To which you made the same response. And
so it went on, throgh numerous iterations, with you responding with the
same silly response rather than a reasoned argument. TM then made an
unwise statement, but your response was out of line (IMO).

And ... I have seen you make the same sort of comment on other postings
many times.

--
---
HTH

Bob


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



"T. Valko" wrote in message
...
Yes it is.

milked it

????????


--
Biff
Microsoft Excel MVP


"Bob Phillips" wrote in message
...
Oh come, that is not a serious question.

--
---
HTH

Bob


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



"T. Valko" wrote in message
...
How so?

--
Biff
Microsoft Excel MVP


"Bob Phillips" wrote in message
...
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.