My data consists of a month column A (1 through 12) and a values column B (financial returns) spanning multiple years. How do I count the number of month occurrences in the second half of the year with positive returns?
Let's also say I have values 1 through 12 in a third column C
A formula like this does not seem to work:
=COUNTIFS($B$2:$B$999, ">0", $A$2:$A$999, ">=C6")
C6 simply equals the number 6. I can't seem to pass on boolean/inequality values into the ifs criteria using a cell reference. How do I get around this? I tried removing quotes and using the & but still no luck.
Column B = Returns, Column A = Months (1-12), Column C = 1 through 12 (to present a table of counts).
Thanks for any help! Much appreciated!