LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Is anyone a SUM(IF formula expert (array formulas)?

I am trying to find costs associated with certain project numbers and do two
different things. One, sum the positive numbers, and two, sum the negative
numbers. I have been able to use the array formula SUM(IF(......)).
However, I am having trouble separating the positive from the negative
numbers. I need more than just the net total.... HELP!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Array Formula Not Working with Range with Formulas [email protected] Excel Discussion (Misc queries) 4 February 1st 06 02:01 PM
another EXPERT LEVEL FORMULA from me Tim Excel Discussion (Misc queries) 2 November 8th 05 11:11 AM
expert with formulas needed again rvnwdr Excel Discussion (Misc queries) 4 June 23rd 05 12:46 PM
Array formulas andreas Excel Worksheet Functions 2 June 1st 05 01:45 PM
MVP...Formula expert needed!!! tkacoo Excel Worksheet Functions 4 April 19th 05 06:44 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"