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