| 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. |
| 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 | |||
Threaded Mode
