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 ...
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")