Count w/colorfunction and two criteria

I am attempting to count w/two criteria. A1:A20 = shaded cells/B1:B20 = text values. I have the correct vba 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))

I'm attempting to show how many cells of identical color have the same data in another column as well.

Suggestions? The VBA code is listed below.

Thanks!

Please Login or Register  to view this content.

Hi,

please put your code between code tags like this: [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]. That will make the code easier to read and copy. HTML otherwise strips out indentation and consecutive spaces.

While you're waiting for a reply, you may want to check the forum rules to find out how to post properly and get brilliant results!


cheers

Figboot, thank you for adding tags however please note you should always amend your original post (else you're not really resolving the problem at hand).

On this occasion I've modified for you.