Prev: Excel - How to get tab to go to next unlocked cell across columns
Next: When refreshed, some Pivot Table columns retain formatting, some d
From: mel on 22 Apr 2010 11:25
I've figured out how to make cell X display the number of hours entered into
D9 if the text "Stat Worked" appears in D11, but now I need to do the same
for columns E through Q, and sum the results.

=IF(D11="Stat worked", D9, 0)

Any thoughts?


From: Glenn on 22 Apr 2010 12:27
mel wrote:
> I've figured out how to make cell X display the number of hours entered into
> D9 if the text "Stat Worked" appears in D11, but now I need to do the same
> for columns E through Q, and sum the results.
>
> =IF(D11="Stat worked", D9, 0)
>
> Any thoughts?
>
>

Do you mean all in one cell? Then try this:

=SUMIF(D11:Q11,"Stat worked",D9:Q9)

From: Eduardo on 22 Apr 2010 12:46
Hi,
I am not sure I understood you, you want to check cells D11 to Q11 and if
the text "Stat Worked" shows up, you want to sum cells D9 to Q9 if the answer
is yes use

=sumproduct(--(D11:Q11="Stat Worked"),D9:Q9)

"mel" wrote:

> I've figured out how to make cell X display the number of hours entered into
> D9 if the text "Stat Worked" appears in D11, but now I need to do the same
> for columns E through Q, and sum the results.
>
> =IF(D11="Stat worked", D9, 0)
>
> Any thoughts?
>
>
From: mel on 22 Apr 2010 13:09
That's perfect!
Now I have realized that I also need it to sum d10 to q10, is there a way to
add this to the formula?

"Eduardo" wrote:

> Hi,
> I am not sure I understood you, you want to check cells D11 to Q11 and if
> the text "Stat Worked" shows up, you want to sum cells D9 to Q9 if the answer
> is yes use
>
> =sumproduct(--(D11:Q11="Stat Worked"),D9:Q9)
>
> "mel" wrote:
>
> > I've figured out how to make cell X display the number of hours entered into
> > D9 if the text "Stat Worked" appears in D11, but now I need to do the same
> > for columns E through Q, and sum the results.
> >
> > =IF(D11="Stat worked", D9, 0)
> >
> > Any thoughts?
> >
> >
From: Luke M on 22 Apr 2010 13:38
=SUMIF(D11:Q11,"Stat Worked",D9:Q9)

--
Best Regards,

Luke M
"mel" <mel(a)discussions.microsoft.com> wrote in message
news:B1C0DD81-D3EF-401D-AA40-45656A1B9BF4(a)microsoft.com...
> I've figured out how to make cell X display the number of hours entered
> into
> D9 if the text "Stat Worked" appears in D11, but now I need to do the same
> for columns E through Q, and sum the results.
>
> =IF(D11="Stat worked", D9, 0)
>
> Any thoughts?
>
>


 |  Next  |  Last
Pages: 1 2
Prev: Excel - How to get tab to go to next unlocked cell across columns
Next: When refreshed, some Pivot Table columns retain formatting, some d