COUNTIFS Function for Multiple Data in the Same Cell

First of all, you don't need to put an = sign in the conditions, as this is assumed.

You can use the wildcard character * before and after your condition to enable you to count if "Hearing" is contained anywhere within the cells, like this:

=COUNTIF('Group_Details'!$R$4:$R$53,"*Hearing*")

or if Hearing is in C5, you can use it this way in D5:

=COUNTIF('Group_Details'!$R$4:$R$53,"*"&C5&"*")

Copy up and down for the other criteria.

Hope this helps.

Pete

Exactly what I was looking for. Thanks, Pete

/SOLVED

Thanks for marking the thread as SOLVED - glad to be of help.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

Duly noted and reputation added. Will more than certainly need assistance going forward with more complex things like setting sheets as templates, and the OFFSET function.

Thanks for that.

I always try to avoid the OFFSET function, as it is volatile and can slow the workbook down. You can often use INDEX to achieve the same results.

Anyway, feel free to post back when you have other problems to solve. It always helps if you attach a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button), as it doesn't work on this forum.

Hope this helps.

Pete