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: Duke Carey on 22 Apr 2010 13:46
=sumproduct(--(D11:Q11="Stat Worked"),D9:Q9,d10:q10)

"mel" wrote:

> 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: mel on 22 Apr 2010 14:18
Hmm, that didn't seem to work.

Here's what I am trying to do...

I have 3 rows, the top 2 display number of hours worked in day shift or
night shift, respectively. The third row has text fields, and if someone
inputs "stat worked" into any of the text fields, I need the number of hours
(whether in the day row or the night row), to be carried over to cell x.
(Cell X should display the sum total of any stat hours worked.)

"Duke Carey" wrote:

> =sumproduct(--(D11:Q11="Stat Worked"),D9:Q9,d10:q10)
>
> "mel" wrote:
>
> > 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?
> > > >
> > > >
First  |  Prev  | 
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