| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Last non-blank cell in a column | Excel Discussion (Misc queries) | |||
| Warning message if one column contains any text and another column is blank | Excel Worksheet Functions | |||
| sum using or (if Blank cell in Column) | New Users to Excel | |||
| HOW DO I COPY THE LAST NON BLANK CELL IN A COLUMN | Excel Worksheet Functions | |||
| Value of last non-blank cell in a column | Excel Worksheet Functions | |||
Linear Mode
