Count column value then adjacent column cell fill color

Good morning,

This is above my pay grade... and any help would be greatly appreciated!

Below is a pic... and further below is an attachment.

I would like to count if: the values in Column A... and then... count if... the cell fill color is in Yellow... in Column B.

I know a COUNTIF formula works for the first part... but the second part regarding color... has me stuck.

I would like to calculate as in the "RESULTS" below.

SAMPLE PIC.jpg

COUNT COLUMN VALUE THEN ADJACENT COLUMN CELL FILL COLOR.xlsx

Thanks!

Kevin

How many CAR's you have? I can try to write a macro for 2 or 3, but if you have 100, my skills won't be enough.

Thanks bmouse... but I do have a total of 19 cars.

Thanks anyway!

19 is not much, but the way I would write this macro is through IF's. First determine the value of the cell, then the color, and that means I would have to write 19 cases of IF to count all cars and colors. That is not an efficient way of doing it, but sadly I haven't yet mastered another. Here's to hoping somebody comes up with a better idea

very Good example for both code above.