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?
|