multiple IF calculations

M

mel

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?
 
G

Glenn

mel said:
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)
 
E

Eduardo

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)
 
M

mel

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?
 
M

mel

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top