Thank you in advance for any help.

=SUMIFS('[ppc worksheet- Jed''s Copy.xlsm]Sheet1'!$C:$C,'[ppc worksheet- Jed''s Copy.xlsm]Sheet1'!$A:$A,$A64,'[ppc worksheet- Jed''s Copy.xlsm]Sheet1'!$B:$B,"*"&"bw"&"*")