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

Yes
personally I would suggest =SUMPRODUCT((a5:a44<>"")*(g5:g44<0.7))

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

The formula works but I just realized that since this is to count grades and I need to count the grades that are >.70 but <than .79 to get how many students got a C grade, the formula you gave me counts >.70 and above. I tried playing around and used this

=(SUMPRODUCT((A5:A44="EE")*(G5:G44>0.77*(G5:G44<0. 79))))

but for some reason is counting all everything between 70 and 79 even though the A5:A44 or doing something else because is giving me a wrong counting

Perhaps =SUMPRODUCT((A5:A44="EE")*(G5:G44>0.77)*(G5:G44<0. 79))

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

NOPE, I uploaded a dummy . Can you check?

Attached Files

DUMMY2.xlsx (19.1 KB, 7 views)

I think I already asked you ro read the proposed solutions carefuly before stating " doesn't work". ( see the placing of parenthesis in my last post which you did not follow)

• Your solution in I8 does NOT meet the requirements (D8 is empty)
• In G17 you try to find numbers that are AT THE SAME TIME larger than 0.9 and smaller than 0.1, which is clearly impossible.
• I suppose you meant >0.9 and <=1. There are thus only TWO who meet the conditions
• See attached with solutions with blue background

Attached Files

Copy of DUMMY2.xlsx (19.9 KB, 11 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I am sorry, You are right!! Thks!