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!

`">=" & C6`

– Scott Craner Dec 3 at 22:04`">0"`

to`">"&0`

. It isn't absolutely necessary but it would make future editing more obvious. – Jeeped Dec 3 at 23:16