IF COUNTIF & COUNTA on Filtered Visible Cells

T

Tinä

Hi Aladin,

Thanks for reply. However, the formula when entered on a sampl
section in Column "T" only gives me a sequential count starting fro
eg: 0-40 down Column "T". It is not returning the expected result
based on the text in Column "V" that I've enclosed in quotation mark
within curly brackets for the array element: {"Executive", "Trainees"
"Manager", "Admin"}.

Further assistance appreciated.

Thanks
Tinä
 
Top