If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multiple IF calculations
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? |
#2
|
|||
|
|||
multiple IF calculations
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) |
#3
|
|||
|
|||
multiple IF calculations
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? |
#4
|
|||
|
|||
multiple IF calculations
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? |
#5
|
|||
|
|||
multiple IF calculations
=SUMIF(D11:Q11,"Stat Worked",D9:Q9)
-- Best Regards, Luke M "mel" wrote in message ... 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? |
#6
|
|||
|
|||
multiple IF calculations
=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? |
#7
|
|||
|
|||
multiple IF calculations
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? |
Thread Tools | |
Display Modes | |
|
|