Posted to microsoft.public.excel.programming

external usenet poster

Posts: 923

SUMIF Question

Hi All
I use the SUMIF worksheet function to SUM a range conditionally, eg

SUMIF(A1:A5,"",B1:B5), which works great for summing B1:B5 if any cell in
A1:A5 is blank

I now wish to reverse the logic and sum if any cell in A1:A5 are NOT blank,
but

SUMIF(A:A5,NOT(""),B1:B5) does not work !

Please help

--
Cheers
Nigel

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 Question	Mark	Excel Discussion (Misc queries)	2	April 15th 09 04:28 PM
SUMIF question	alice	Excel Discussion (Misc queries)	2	November 24th 05 02:55 PM
SUMIF Question	Minitman[_4_]	Excel Programming	4	November 6th 04 10:45 PM
sumif question	No Name	Excel Programming	5	September 24th 04 11:02 PM
sumif question 2	Tom Ogilvy	Excel Programming	0	September 24th 04 06:19 PM

All times are GMT +1. The time now is 09:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us