Hi!
Yesterday, someone help me with a formula which is working super.
Now I realized that I need to count the cells which I applied a conditional formatting. I know this can only be accomplish with Vba but I don't want to use it. So I was thinking if count if or ifs can help me. The problems is I have tried and is not working. Here is what I want



I have this for the conditional formatting to turn the cell red
=AND($A5<>"",$G5<0.7)

Is it possible to count all the cells in a row A5:A44<>"",G5:G44<.07 that meet the same conditions?

Thanks for always helping
Liz