#### Colleen905

##### New Member

- Joined
- Feb 17, 2016

- Messages
- 3

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?