Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 72

IF and SUMIF

So this is what I want to do...
Sum of all negative numbers in range, if there are no negative numbers in
range display 0, if cells in range are blank display "". I tried using
something like this:

IF(B6:E6="","",SUMIF(B6:E6,<0,B6:E6))

Not sure how to do this, hope you can help!

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	sumif	Excel Worksheet Functions	1	February 4th 08 02:32 AM
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"	Harry Seymour	Excel Worksheet Functions	9	June 12th 07 10:47 PM
Embedding a Sumif in a sumif	C.Pflugrath	Excel Worksheet Functions	5	August 31st 05 07:31 PM
nested sumif or sumif with two criteria	dshigley	Excel Worksheet Functions	5	April 5th 05 03:34 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function	Oscar	Excel Worksheet Functions	2	January 11th 05 11:01 PM

All times are GMT +1. The time now is 01:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us