Forum Discussion
Jim-5
Jun 29, 2019Copper Contributor
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 ...
SergeiBaklan
Jun 29, 2019Diamond Contributor
COUNTIF() shall work, but better if you provide small sample file
Jim-5
Jul 01, 2019Copper Contributor
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 () ?
- SergeiBaklanJul 01, 2019Diamond Contributor