finding the right formula to calculate values

[Colleen905]

Question: find the appropriate function to count how many of the cells in the range (F20:F23) evaluate to a value of Yes.

Met Cdn $ Targets?
No (=IF(C20>=K20,"Yes","No"))
Yes (=IF(C21>=K21,"Yes","No")		)
No (=IF(C22>=K22,"Yes","No"))
Yes (=IF(C23>=K23,"Yes","No"))
# of products on target: ?(Formula needed) F20 to F23 has formulas for their cells which I have in brackets above

<colgroup><col span="3"></colgroup><tbody>
</tbody>

I tried to use VLOOKUP:
=VLOOKUP("Yes",F20:F23,1,FALSE)
but it doesn't count the 2 Yes's. perhaps the wrong formula?

 

[radian89]

Hi Colleen905,

can you provide screenshot? and what's currently the problem & what to achieve here?
A little bit confuse with the question like

Met Cdn $ Targets? # of products on target: ?(Formula needed)

you can use dummy file if its confidential.

thanks
Warm regards,
Adrian

 

[Aladin Akyurek]

Are you after?

=COUNTIFS(F20:F23,"Yes")

 

[MandeepBaluja]

=COUNTIF($A$3:$A$11,"YES")
=SUM(--($A$3:$A$11="YES")) with Ctrl+shift+enter many wayss to do this

 

[Colleen905]

ADVERTISEMENT

Are you after?

=COUNTIFS(F20:F23,"Yes")

That was the formula exactly!!! Thank you!!! ok I can go to sleep now lol

 

[Colleen905]

sorry I shouldn't have put that part in as it was irrelevant for the question...but I did get the answer with was the COUNTIF formula. Sorry about that

 

[Aladin Akyurek]

That was the formula exactly!!! Thank you!!! ok I can go to sleep now lol

sorry I shouldn't have put that part in as it was irrelevant for the question...but I did get the answer with was the COUNTIF formula. Sorry about that

You are welcome. Thanks for the update!...