How to use sumifs for multiple criteria

Question

i am looking to add a column values if it matches multiple criteria

i like to get sum of Column-c if Column-E range is in Column-B and Column-D = A1

i tried with single criteria using below formulae =SUMPRODUCT(sumif(E4:E13,B4:B18,C4:C18)) but not able to add one more criteria

user_5632629 · Answer

if you have multiple criteria you should go with SUMIFS

or do:

=SUM(FILTER(C4:C, D4:D="A1", COUNTIF(B4:B, E4:E)))