Need Help Calculating Wins/Losses, and Avg Win/Loss

[sacajamo]

Working on a spreadsheet for some daytrade data, I needed help calculating a couple of things. See column below as an example:. If I wanted to calculate "win-loss" as an output of 7-3 (any positive # is a win, any negative # is a loss, and it would be considered a "tie" if $0). Second question, is there a formula that would only pull the 7 "wins" below and compute average win and another that pulls the 3 "losses" and computes average loss.

Win/Loss
$1.96
-$0.87
$0.80
-$0.26
-$2.64
$2.05
$0.56
$0.52
$2.05
$3.00

​

 

[Cubist]

How about this?

Book2
	A	B	C	D	E
1	Win/Loss			Win	Loss
2	$1.96		Count	7	3
3	($0.87)		Average	1.56285714	-1.2566667
4	$0.80
5	($0.26)
6	($2.64)
7	$2.05
8	$0.56
9	$0.52
10	$2.05
11	$3.00
Sheet1

Cell Formulas
Range	Formula
D2	D2	=COUNTIF(A2:A11,">0")
E2	E2	=COUNTIF(A2:A11,"<0")
D3	D3	=AVERAGEIF(A2:A11,">0")
E3	E3	=AVERAGEIF(A2:A11,"<0")

 

[sacajamo]

I believe this works. Thanks, Cubist!