Need some help with a formula that is driving me crazy today. I am hoping that it is a "senior moment" and this is an easy fix.
I have a table on a worksheet "dashboard". The Managers names frun from B4 to B12. What I need to do is count the number of visible cells on the tab "stockouts" in column f4:f5000. The managers name are in A4:A5000 on the stockout tab. Column F is just "yes" or "no". I need to have the formula is "dashboard--cell H2:H12"
This is what I have so far but it is giving me a number that is way off.
Any help is appreciated.
Thanks in advance!