Thread: multiple IF calculations
View Single Post
  #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?