SUMIF/SUMPRODUCT Multiple Criteria

Hi all,

I've seen similar posts on here but they have not quite answered my question. I have a range of data that I need to sum based on multiple criteria. Please see the attached excel file.

I'd like to be able to sum Column A with a criteria that is A,B,C,D (defined in E6:E9) and 1,2,3,4 (defined in F6:F9). I'd like to reference Columns E and F so that I could add or remove criteria in the future without changing the formula. I've seen this done with one criteria using something like =SUMPRODUCT(SUMIF(B1:B9,E6:E9,A1:A9)) to get 423, but I'm looking further to then see out of that, the sum of numbers that have 1,2,3, or 4 in column c.

Thank you in advance!

Perhaps

=SUMPRODUCT(SUMIFS($A$1:$A$9,$C$1:$C$9,F6:F9))

I'd need this to be done with a single formula if possible. The answer that should be populated is 238. The previous responses yielded an answer of 241?

When you do 2 sets of multiple criteria, each set must be transposed of each other.
i.e., one a column like E6:E9, the other a row like H6:K6

Try
=SUMPRODUCT(SUMIFS(A1:A9,B1:B9,E6:E9,C1:C9,H6:K6))

Ah Jonmo1's solution worked, thank you!

You're welcome.