| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF evaluating blank DATE data
Hmm, this daft/simple formula has got me stumped.
I have a simple table with column C that contains numeric values, and column D that contains date values. All I want to do is a calculate the SUM of cells in column C that do not have a date value in column D. Something like this... but obviously this does not work, possible as the evaluated data type is a date. Any ideas? =SUMIF('TRAVEL ADVENTURES'!D3:D105,"NOT(ISBLANK)",'TRAVEL ADVENTURES'!C3:C105) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif returns blank if all cells blank | Excel Worksheet Functions | |||
| #Value! error when evaluating data in a cell range | Excel Worksheet Functions | |||
| Evaluating a start and an end date | Excel Discussion (Misc queries) | |||
| SUMIF finds data when Criteria is blank | Excel Discussion (Misc queries) | |||
| Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
Threaded Mode
