Forum Discussion
Countif
Is there a way of counting a specific word in a column but not count the word if it's in a coloured cell?
1 Reply
- if color is given by conditional formatting you can use the same condition in COUNTIFS formula. otherwise there is no formula to get cell color. the only way is to create a table with filter and try to count with aggregate
