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)