[masraum]

Originally Posted by rattlsnak

Omg... that worked! I had to do =COUNTIF('Form Responses '!$F:$F,D1) to get it to do what i needed. Let me know if that looks funky, but it works!

Thank you!!!!

No, it doesn't look funky to me. Anywhere that you need to anchor a reference, the $ is what you need, at least, in my experience.

If you just need to get a count per person in a list, then a pivot table might be the fastest way to do that, but without knowing exactly what you're working with and what you need, I can't say for sure. If you've gotten this to work and it's giving you what you need, then that's perfect. And I am far from an excel expert so I could be wrong.