SUM values in this column F only if cell is blank in column Q...HE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top