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
or do:
=SUM(FILTER(C4:C, D4:D="A1", COUNTIF(B4:B, E4:E)))
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
or do:
=SUM(FILTER(C4:C, D4:D="A1", COUNTIF(B4:B, E4:E)))