I need to check in a single column for any of 20-40 values and total those occurances. Here is what I wish I had:
=COUNTIF(J:J, {"Fred", "Ethel", "Ricky", "Lucy", "Marvin", "Marilyn", "Janis"}) where this would return all of the occurrances of Fred, Ethel, Ricky, Lucy, Marvin, Marilyn and Janis in col J.
Because I have 20-40 values I need to count I do not want to string 20-40 COUNTIF functions together ala =COUNTIF(J:J, "Fred")+COUNTIF(J:J, "Ethel")...
How can I make this simple and succinct?
Thanks!
Bookmarks