Hi guys,

I have inserted a module into a spreadsheet which counts the colors of cells using this formula: =CountCcolor(U8:U121,$T135) where T135 is a reference cell containing the pink color.

I am now trying to combine this with a countif function.

So I'd like it to return how many people have the colour pink and have either A,B1, B2 or B3 in the cell.

=COUNTIFS(U8:U121,"B3")+COUNTIFS(U8:U121,"B2")+COUNTIFS(U8:U121,"B1")+COUNTIFS(U8:U121,"A")

Any help appreciated as always.