Sum/ Count colored cells based on conditional formatting

Hi all

So I have a spreadsheet in which cells in the Value column(B) are formatted to red when the value is below target (column C) and then formatted green when the value has met or exceeded target. I need to show what percentage of targets have been met.

So for example in my attached document , there are 2 cells out of three that are in red. If I could count the red cells and the green cells , i would be able to calculate a percentage. If anyone can please help with a formula for this, I'd be really happy!

Thank you

This will give you the percentage of targets that have been hit (i.e. percentage of total cells in column B that are green):

=SUMPRODUCT(--(B2:B4>=C2:C4))/COUNT(B2:B4)

For green:

=SUMPRODUCT(--(B2:B4>=C2:C4))

For Red:

=SUMPRODUCT(--(B2:B4<C2:C4))

Thank you, great!!

How can I amend the formula so that it excludes any targets in column C that are N/A, therefore the value in column B will not be formatted to either red or green. See below for an example

Value Target
Referrals 5 10
Appraisals 7 4
Complaints
handled 93% 100%
Accepted 5 N/A

Just bumping this up. Any help would be greatly appreciated !