Add results of an IF function

[avikavik]

Hi all,
I am trying to simplify the following task:

My excel sheet contains a work schedule:
- each row consists of the daily shift timetable of supervisors (30 supervisors) during a 3months period (shift work, so the cells contain text which says morning, evening or night).
- on row 36, i am copying the timetable of a junior staff.

I need to know how many times each supervisor worked with the junior staff member over the whole 3 month period (matching text values in the same column).
For now, I have used:
1) an IF function (=IF(B2:CG2=B36:CG36),"1",""). This generates a whole new table with 0 and 1 for each day.
2) a CountIF to know the number of 1's in the new table.

Could anyone tell me if there is an easier way to get the total number of cells at the end of each row which match the junior staff's cell (in the same column)? I have tried fiddling with multiple functions but can't figure out an easy way....

A million thanks to all excelgurus out there, and sorry if this is very basic

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=SUM(--(B2:CG2=B36:CG36))