At work I am getting java errors whenever I try to use 'search' and it won't display results, but I have searched all over google with no luck. I'm trying to count how many cells are filled with a specific color and only the ones that have data in them. The following formula returns 0 :confused:
=COUNTIF(B47:O146,AND(COUNTIF(B47:O146,">"""),ColorFunction(O14,B47:O146)))
Seperatley, the counts work, I just can't figure out how to combine them.