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