Colleen905
New Member
- Joined
- Feb 17, 2016
- Messages
- 3
Question: find the appropriate function to count how many of the cells in the range (F20:F23) evaluate to a value of Yes.
<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?
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?