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

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.

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

=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.

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

=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.

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

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.