View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Johnson31d Johnson31d is offline
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!!!