hello,
im using the following formula which counts the amount of rows that have ALL these words/conditions:
Formula:Please Login or Register to view this content.
However, instead i want it to do exactly the same thing but in column I on Sheet1, I dont just want "Red".
I want it to count if there is either "Red", "Gold", or "Silver".
ive tried using the funny looking brackets to no avail:
Formula:Please Login or Register to view this content.
how can this be done?
thank you
Bookmarks