Counting multiple items in a single dropdown list

MeganHaro

I'm tracking evaluations completed per month and in mydropdown list I have selections including:

"Personal delivery"

"Email"

"Personal deliveryx2" (recently added)

"Email x2"(recently added)

Ona helper page, I was using a countif formula to count "personaldeliveries" only. But now that I want to count "personaldeliveries" and "personal deliveries x2" together, I cannot seemto find the right formula.

Jason Tarpinian

Try using:

=COUNTIFS({Reference Range Here}, AND(HAS(@cell, "Personal delivery"), HAS(@cell, "Personal deliveryx2")))

And just replace {Reference Range Here} with whatever your dropdown column is.