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.
Bookmarks