I am in worksheet 1, trying to figure out a formula to count the number of cells/rows in worksheet 2, that contain the combination of letters "ARC" in column C plus either a "W" or a "R" in column D.
The result is in worksheet 1 and the data is worksheet 2. I need a count of how many people from ARC registered on either W or R.
ARC (in column C) + "W" or "R" in column D.
I looked at other posts and got thoroughly confused because I didn't see a formula for multiple criteria in a different worksheet.
Thank you
Bookmarks