I have to count no. of Red values based on filters applied in Desc column from below example. Normal countif works but it shows same no even with filtered list so how to use countif for filtered list.
Desc Value
A Red
B Blue
C Red
D Blue
E Green
F Yellow
G Red
Bookmarks