SUMIF evaluating blank DATE data

[Uncle Spike]

Hmm, this daft/simple formula has got me stumped.

I have a simple table with column C that contains numeric values, an
column D that contains date values.

All I want to do is a calculate the SUM of cells in column C that do no
have a date value in column D.

Something like this... but obviously this does not work, possible a
the evaluated data type is a date. Any ideas?

=SUMIF('TRAVEL ADVENTURES'!D3105,"NOT(ISBLANK)",'TRAVE
ADVENTURES'!C3:C105

 

[Claus Busch]

Hi,

Am Thu, 20 Jun 2013 07:20:03 +0100 schrieb Uncle Spike:

=SUMIF('TRAVEL ADVENTURES'!D3105,"NOT(ISBLANK)",'TRAVEL
ADVENTURES'!C3:C105)

try:
=SUMIF('Travel Adventures'!D3105,"<>",'Travel Adventures'!C3:C105)


Regards
Claus Busch

 

[Uncle Spike]

Many thanks Claus, that worked a treat

Hi,

Am Thu, 20 Jun 2013 07:20:03 +0100 schrieb Uncle Spike:
-

try:
=SUMIF('Travel Adventures'!D3105,"<>",'Travel Adventures'!C3:C105)


Regards
Claus Busch