Originally Posted by Claus Busch

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