Excel Equations 1

[riches85]

I am a novice when using Excel and I have an interesting problem I am hoping someone can help me with. I have a column of calculated dollar totals both negative and positive like so:

$(129.20)
$(129.20)
$(181.24)
$(177.70)
$(8.50)
$(15.50)
$101.13
$77.85
$(175.00)
$(175.00)
$(124.00)

when this column is calculated it gives a net amount of $(936.36) which is what I need. Now I also would like two other cells to tell me the total positive dollar amounts(i.e 178.98) and also a total of the negative figures(i.e 757.38). Is this possible. If anyone had any ideas as to how I may accomplish this, I would really appreciate it. Thanks

 

[KenWright]

SUMIF()

Positive
=SUMIF(A1:A1000,">0")

Negative
=SUMIF(A1:A1000,"<0")

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[riches85]

Thanks! Works Great!

 

[KenWright]

You're welcome

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------