Calling all nerds (ok I'm one too),

I have a large column in excel that I track my P&L with. I'd like to calculate my average win and average loss. Any of you have a formula for this? Basically if its a NEGATIVE number it needs to go to the loss formula and if its a POSITIVE number it needs to go to the win formula. I could separate my P&L in to separate loss/win columns but I'm sure there must be a more elegant way to do it without having to unformat the data like that.

EXAMPLE of how the P&L is organized:
NET
-$199.00
$340.00
$420.00
-$180.00
$659.00
$570.00
-$150.00

The easy way is to have two columns, one for Profits and the other for Losses then take the average of each. Keeping everything in a same column you'll probably need an IF statement within the AVERAGE command.


Event Profit Loss

you could always use a spread sheet someone else has already made.

http://www.fullcontactpoker.com/poker-foru...showtopic=93631

Thanks for the link. I think I will! Or just copy some of their code in to mine. I spent so much time on my sheet that I don't want to murder it quite yet.