I am new to this forum but thanks for any help.

I have one sheet which is a work schedule of 6 weeks at a time. On the
second sheet I was trying to get some totals of the individual employees. The
totals that I was trying to get were for: mon - wed totals, thurs totals, and
fri totals by themselves. The way that I was trying it was by each individual
employee. So for instance, employee Bob: how many times Bob's name appears in
the mon-wed columns, thurs column, and fri column and then sum those totals.
I dont know if I should use functions: if, sum, sumif, countif or a
different. My sheet 2 is referencing or linking to sheet 1 which is my
schedule.
Example:
Mon Tues Wed Thurs Fri
Bob Pat Fred Bob Bob
Pat Lisa Bob Fred Bob

so Mon-wed Bob=2
Thurs Bob=1
Fri. Bob=2
Sorry for the long post just wanted to convey my situation as accurate and
descriptive as possible. Thanks again.