Counting in IF stmt

[Jim-5]

I have a small Investment spreadsheet. Currently I'm tracking six symbols. One column, H5 - H10, tracks the change for each symbol. I'm trying to do two basic things, count the number of winners and count the number of losers in cells B13 and B14 and secondly, total the winnings and loses in B15 and B16.

[#2]

@Jim-5 

COUNTIF() shall work, but better if you provide small sample file

[#3]

@Sergei Baklan 

Thanks for the help.

Group 3A
				TRADE	TRADE		OPEN TRADE		CLOSED
ENTRY DATE	SYMBOL	L/S	SHARES	ENTRY PRICE	LAST PRICE	CHANGE	$ GAIN/LOSS	ROI	TRADE P&L	RISK
66/24/19	FFXE	L	1	108.26	108.27	$                 0.0	$            0.01	0.0%
66/24/19	GLDGLD	L	1	133.5	133.2	$             (0.30)	$          (0.30)	-0.2%
66/24/19	QQQ	L	1	188.5	186.74	$             (1.76)	$          (1.76)	-0.9%
66/24/19	TLT	L	1	132	132.81	$               0.81	$            0.81	0.6%
66/24/19	VXX	S	1	26.6	26	$             (0.60)	$            0.60	2.3%
66/24/19	XOP	S	1	26	27.25	$               1.25	$            1.25	4.81%
Open	Trades			614.86	614.27		$          61.00	9.92%	$          -	#DIV/0!
Stocks	6
Losers	#NAME?					Open P&L	$          61.00
Winners
$ winners						Open Trade	Avg ROI	2.35%
$ Losers
Avg win						Closed P&L	$                -
Avg lose
Profit Factor						Return On Risk	=
Weekly Close	Open & Closed	Equity Change	Weekly Acct
Date	P/L	Plus/Minus	Gain/Loss %

[#4]

@Sergei Baklan 

I'm trying =COUNTIF(H5,<0,"") for the losers but it's not working. BTW - is there a SUMIF () for the totals ?

[#5]

@Jim-5 

The COUTIF() function only has 2 parameters: range and criteria

The formula will work is you select the collection of cells containing winners as losers, making that your range (H5:H10) and your criteria to "L" 

[#6]

@Jim-5 

We may only make a guess where is what in your data. If H5:H10 is the range with numbers in dollars, when number of losers

=COUNTIF(H5:H10,"<0")

and for winners

=COUNTIF(H5:H10,">0")

[#7]

@Sergei Baklan 

Thanks so much Sergei, the formulas worked perfect.

In order to total the numbers for losers and winners, is there an IF statement I use, perhaps =SUMIF () ?

[#8]

@Jim-5 

You may count all not empty cells in this range

=COUNTA(H5:H10)