A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

multiple IF calculations



 
 
Thread Tools Display Modes
  #1  
Old April 22nd, 2010, 04:25 PM posted to microsoft.public.excel.worksheet.functions
MEL
external usenet poster
 
Posts: 249
Default 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  
Old April 22nd, 2010, 05:27 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
 
Posts: 1,245
Default 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  
Old April 22nd, 2010, 05:46 PM posted to microsoft.public.excel.worksheet.functions
eduardo
external usenet poster
 
Posts: 2,131
Default 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  
Old April 22nd, 2010, 06:09 PM posted to microsoft.public.excel.worksheet.functions
MEL
external usenet poster
 
Posts: 249
Default 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  
Old April 22nd, 2010, 06:38 PM posted to microsoft.public.excel.worksheet.functions
Luke M[_4_]
external usenet poster
 
Posts: 451
Default 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  
Old April 22nd, 2010, 06:46 PM posted to microsoft.public.excel.worksheet.functions
Duke Carey
external usenet poster
 
Posts: 1,027
Default 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  
Old April 22nd, 2010, 07:18 PM posted to microsoft.public.excel.worksheet.functions
MEL
external usenet poster
 
Posts: 249
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.