Countif(range of cells, "*Monday*")
Countif(range of cells, "*Tuesday*")
etc.

"crazymfr" wrote:

I have aggregated data in columns that were imported from web forms and are
separated by semicolons. The questions was select your preferred day of week
with a select all that apply option. Any time someone chose more than one
day, it aggregates the response together in the same cell (ie choosing Monday
and Thursday returned a response of "Monday; Thursday" in B1...etc.)

I want to be able to count each instance of Monday regardless of what other
days per response.

Monday - Total
Tuesday - Total
Wednesday - Total
Thursday - Total
Friday - Total.

Below is a sample of data. Please help me! Thanks you.

Wednesday
Monday; Tuesday; Wednesday; Thursday
Tuesday; Thursday; Friday
Tuesday; Wednesday; Thursday
Monday
Monday; Tuesday; Wednesday; Thursday
Thursday
Tuesday; Wednesday
Tuesday; Wednesday; Thursday
Tuesday; Wednesday; Thursday
Monday; Wednesday; Thursday
Monday; Wednesday; Friday
Tuesday; Friday
Thursday
Monday; Wednesday
Tuesday; Wednesday