Home > other >  How to use sumifs for multiple criteria
How to use sumifs for multiple criteria

Time:04-22

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

enter image description here

or do:

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

enter image description here

  • Related