Countiing red cells (cells that turned red based on conditional formatting)

[ranghad]

I want to count the number of cells that are red.
I know this may be done through function
but the challenge i am facing is that in my range cells are colored red with conditional formatting.
Attaching file too...

[S O]

Use the same logic as your CF rule in a COUNTIF formula...

=COUNTIF(F3:I7,"<12")

[ranghad]

My mistake
The actual scenario is that I have data in 12 columns and I color cell values in each column red with conditional formatting. Each column has different criteria to color cell red.

[S O]

You're using a function to define the CF criteria - so just use that in a COUNTIF or COUNTIFS function to get the same result. If you don't supply a true representative sample of your data then you won't get complete answers...

[ranghad]

Attaching the file

Under the countred heading I want the count of cells that are red in columns f to i
the formula works if I manually color the cells red but doesn't if colored red with cf