Uncle Spike Uncle Spike is offline

Junior Member

Posts: 3

Many thanks Claus, that worked a treat :)

Quote:

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumif returns blank if all cells blank	Heliocracy	Excel Worksheet Functions	7	January 19th 09 08:59 PM
#Value! error when evaluating data in a cell range	Simon Woods	Excel Worksheet Functions	7	January 13th 09 10:38 PM
Evaluating a start and an end date	Mark	Excel Discussion (Misc queries)	4	March 12th 08 03:51 PM
SUMIF finds data when Criteria is blank	emea training 2	Excel Discussion (Misc queries)	2	June 14th 06 06:10 PM
Sumif to return a blank if sum range is blank	[email protected]	Excel Worksheet Functions	3	May 25th 06 10:25 AM

All times are GMT +1. The time now is 02:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us