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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Sumif where source values are assigned by "if" formula 3
Sum If Non Blank 6
Averageifs - criteria is cell is not blank 1
sum only certain figures in the column 6
Cells total help. 5
If cell is blank automatically enter today's date in the same cell 21
Returning Value of Next Non-Blank Cell in Column 2

Top