ExcelBanter - SUMIF evaluating blank DATE data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUMIF evaluating blank DATE data (https://www.excelbanter.com/excel-discussion-misc-queries/448906-sumif-evaluating-blank-date-data.html)

Uncle Spike

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)

Claus Busch

SUMIF evaluating blank DATE data

Hi,

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

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

try:
=SUMIF('Travel Adventures'!D3:D105,"<",'Travel Adventures'!C3:C105)

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Uncle Spike

Many thanks Claus, that worked a treat :)

Quote:

Originally Posted by Claus Busch (Post 1612400)

All times are GMT +1. The time now is 04:48 AM.