Forum Discussion
Counting in IF stmt
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 ...
COUNTIF() shall work, but better if you provide small sample file
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 () ?
I'm trying =COUNTIF(H5,<0,"") for the losers but it's not working. BTW - is there a SUMIF () for the totals ?
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")
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"
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 %
