hI GUYS,
I have an issue where i`m trying to write the follwing text in cell J1:
="Auto vetting enabled: " & COUNTIFS(E:E, "Y", F:F, *Active*)
Count all the cells from column, which have a "Y" and are "active" - as indicated in column F. I need the wildcard symbol incase there are different contents with the word active. ss attached.
pls help!
THANKs.
R.
Bookmarks