Sorry for the delay getting back to you. I have been very distracted over the Christmas/New Year period.

I think all you need to do as add that extra bit to the formula :
=SUMPRODUCT(--($B13:$B100=$R13),--($G13:$G100=S$12),--($D$13:$D$100=$R$10),$F13:$F100)

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".