CountCColor and COUNT IF

You cannot simply add or multiply
These are separate/independant conditions, so you probably shall edit code of CountCcolor to allow one more argument, like

Please Login or Register  to view this content.

You could do this with COUNTIFS, becasus conditioons were dependent on each other.
Cell with A is for sure not cell with B1 or B2 of anything else than A.

ok could you please show me what you mean using this code

Please Login or Register  to view this content.

For instance write B3, B2 etc in some range and supply it as third argument to

Please Login or Register  to view this content.

Please note how CODE tags improve readability and edit your post to comply with [/I]Rules of our Forum .

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Hi,
My idea was that you just list somewhere in a worksheet all values

B3
B2
B1
A

Let's say you did it in Z1:Z4 range

so write:

Formula:

Please Login or Register  to view this content.