One way,
=SUMPRODUCT(--('117'!F8:F300),--(ISBLANK('117'!Q8:Q300)))
Regards,
Alan.
"Lisa" wrote in message
...
I would like to add the values from worksheet '117' in column F ONLY if the
corresponding cell is blank in column Q. I DO NOT want the to include
where
the cells have text entered. I've tried....from someone else's
suggestion,
but it doesn't seem to work.

=SUM(--NOT(ISBLANK('117'!Q8:Q300)),'117'!F8:F300)

Thank you for your suggestions.