Countifs Formula returns #Value error

Hi I am trying to create a formula that will count cells that are true, and are a certain colour. I have a macro in place that allows me to count by colour.

My formula right now is =COUNTIFS(IF(W2:W200,"YES"),colorfunction(AN2,A2:A200, FALSE))

If anyone has any insight on how to make this work it would be immensely helpful!

Thanks,



Nick

COUNTIFS works with ranges, not arrays