I am very much a beginner on Access and am trying to migrate an Excel workbook into an Access Database as it is far more suitable. However, one piece I am stuck on is replicating the following formula in Access format:

=SUMPRODUCT(('Source Data'!$L$2:$L$500="PERFORMANCE")*('Source Data'!$E$2:$E$500="I")*('Source Data'!$I$2:$I$500<>"Subcontractor"))

How can I do a calculated field to count 3 sets of data over the 3 column headings?

Any help greatly appreciated.