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
|