Forum Discussion
North_Yorks
Sep 23, 2020Copper Contributor
COUNTIF function but with conditional formatted cells
Hi, I have a spreadsheet that uses conditional formatting via a drop down list that the cell changes colour depending on result. I want to be able to count the number of cells that are certain co...
HansVogelaar
Sep 23, 2020MVP
Instead of counting the cells by colour, count them based on the values of the cells.
North_Yorks
Sep 23, 2020Copper Contributor
Hi i have found a function COUNTIFS that seems to work. Thanks