Sum only negative or positive amounts

[Riaang]

Hi, I have a spreadsheet of members accounts ageing detail for a company spliting them according to the differnt sections within the company. It gives the name, ref no, section code and then the ageing for 90days, 60days, 30days and current. What I want to do is add subtotals at each change in the section code and add totals to 90days, 60days, 30days and current. The catch is I only want it to add all the negative numbers per ageing group and then after extracting the totals it must do the same but with the positive numbers. eg if in the 90days column you have member1 with 300.00, member2 with -600.00 and member3 with 200.00 the answer I want in the 90days column must be -600.00 if summing the negatives and 500.00 when summing the positives.

 

[PaddyD]

what was wrong with aladin's suggestion? If it doesn't work, it could be because you haven't yet given enough info for the correct solution to be determined. post back with more details about how your data is set up. Work through an example explaining what data you'd have & what outcome you'd expect. May be download the html maker add in from the link below this post & post up a snapshot of your data.

More details please...

Paddy

 

[Ajit.Koul]

Try this
So you want to add up only the positive numbers in a column.

<CENTER>=SUM(IF(B10:B40>=0,B10:B40,0)) </CENTER>
Enter the formula; then hold Ctrl and Shift while pressing the Enter key to tell Excel that you are entering an array function

 

[Aladin Akyurek]

Try this
So you want to add up only the positive numbers in a column.


<CENTER>=SUM(IF(B10:B40>=0,B10:B40,0)) </CENTER>
Enter the formula; then hold Ctrl and Shift while pressing the Enter key to tell Excel that you are entering an array function

=SUMIF(B10:B40,">0",B10:B40)

Or the shorter version...

=SUMIF(B10:B40,">0")

would be faster...