I am attempting to count w/two criteria. A1:A20 = shaded cells/B1:B20 = text values. I have the correct macro to make the colorfunction formula work on its own, but am having difficulty making it work with two criteria. (C1 = shade criteria, D1 = text criteria)
This is what I have now:
=SUMPRODUCT(--(colorfunction(C1,A1:A20,FALSE)),--(B1:B20=D1))
Suggestions?
Thanks!
This is what I have now:
=SUMPRODUCT(--(colorfunction(C1,A1:A20,FALSE)),--(B1:B20=D1))
Suggestions?
Thanks!