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?