=SUMIF('117'!Q8:Q300,"",'117'!F8:F300)

"Teethless mama" wrote:

=SUMPRODUCT(--('117'!Q8:Q300=""),'117'!F8:F300)


"Lisa" wrote:

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.