Everyone has been so much help. I've got one more question -- and I'm not
going to promise you it will be my last. :)

I have a free text comment cell that I need to search for certain words.

=SUMPRODUCT(--('Survey Data'!C2:C500="Bell"),--('Survey
Data'!J2:J500"contains the words optional exam"))

I need to put in the code that will search for the words "optional exam"
within a free text cell.

Any help would be gladly appreciated.

--
Beverly C.