Counting in IF stmt

Question

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.

sergeibaklan · Answer

Jim-5&nbsp;
COUNTIF() shall work, but better if you provide small sample file

jim-5 · Answer

SergeiBaklan&nbsp;Thanks for the help.Group 3A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TRADETRADE&nbsp;OPEN TRADE&nbsp;CLOSED&nbsp;&nbsp;ENTRY DATESYMBOLL/SSHARESENTRY PRICELAST PRICECHANGE$ GAIN/LOSSROITRADE P&amp;LRISK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;66/24/19FFXEL1108.26108.27&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.0&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.010.0%&nbsp;&nbsp;&nbsp;66/24/19GLDGLDL1133.5133.2&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.30)&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.30)-0.2%&nbsp;&nbsp;&nbsp;66/24/19QQQL1188.5186.74&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (1.76)&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (1.76)-0.9%&nbsp;&nbsp;&nbsp;66/24/19TLTL1132132.81&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.81&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.810.6%&nbsp;&nbsp;&nbsp;66/24/19VXXS126.626&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (0.60)&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.602.3%&nbsp;&nbsp;&nbsp;66/24/19XOPS12627.25&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.25&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.254.81%&nbsp;&nbsp;&nbsp;Open&nbsp;Trades&nbsp;&nbsp;614.86614.27&nbsp;&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 61.009.92%&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;#DIV/0!&nbsp;Stocks6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Losers#NAME?&nbsp;&nbsp;&nbsp;&nbsp;Open P&amp;L&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 61.00&nbsp;&nbsp;&nbsp;&nbsp;Winners&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ winners&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Open TradeAvg ROI2.35%&nbsp;&nbsp;&nbsp;$ Losers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Avg win&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Closed P&amp;L&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Avg lose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Profit Factor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Return On Risk=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Weekly CloseOpen &amp; ClosedEquity ChangeWeekly Acct&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DateP/LPlus/MinusGain/Loss %&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

jim-5 · Answer

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

excel_world_champion · Answer

Jim-5&nbsp;The COUTIF() function only has 2 parameters: range and criteriaThe 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"&nbsp;

sergeibaklan · Answer

Jim-5&nbsp;
&nbsp;
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,"&lt;0")
and for winners
=COUNTIF(H5:H10,"&gt;0")

Forum Discussion

Counting in IF stmt

7 Replies

Resources