SUMPRODUCT Vertical & Horizontal

[gomukuma]

Hi There.

I need to add a further stipulation to a formula im using, but it doesn't quite seem to be as simple as i thought and wonder if anyone could help.

DATA (Unsocials)

MACH	SHIFT	Sun 30 Apr	Mon 1 May	Tue 2 May	Wed 3 May	Thurs 4 May	Fri 5 May	Sat 6 May	Sun 7 May
		Month1	Month2	Month2	Month2	Month2	Month1	Month2	Month2
X	AM	Paul						Paul	Zoe
X	PM	Shane						Sarah	Shane
Z	AM	Sarah						Phil	Jenny
Z	PM	Jenny						Peter	Paul

<TBODY>
</TBODY>

There is a column for every day of the year


Summary (Table14)

Initials	Sat Unsocial (PM)	Sun Unsocial (AM)
Sarah	1 (formula)	1
Jenny	0	1
Paul	0	0
Phil	0	0
Peter	1

<TBODY>
</TBODY>

So int this part of the Summary, i am calculating how many SAT PM / SUM AM Shifts have been worked for each employee. I can't change the data around because its linked to a roster.

This is the formula im using at the moment which will count the number of Saturdays/Sundays.
=SUMPRODUCT((Unsocials!$C$1:$NC$1="Saturday")*(Roster!$C$72:$NC$72=Table14[[#Headers],[Month 1]])*(Unsocials!$C$4:$NC$39=[@Initials]))

I need to add to this so it will only count the Saturdays is a PM in column B on the DATA Sheet.

This is the final peice of my puzzle, any help would be grately appreciated!

Thank you!