ExcelBanter - Sumif with two criterias

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sumif with two criterias (https://www.excelbanter.com/excel-worksheet-functions/118268-sumif-two-criterias.html)

leung

Sumif with two criterias

How can I use sumif when I want to meet two criteria?

Biff

Sumif with two criterias

I'm guessing you have 2 criteria in 2 different columns?

A1 = criteria1
A2 = criteria2

=SUMPRODUCT(--(B1:B10=A1),--(C1:C10=A2),D1:D10)

Sums D where B = A1 and C = A2

Biff

"leung" wrote in message
...
How can I use sumif when I want to meet two criteria?

All times are GMT +1. The time now is 09:20 AM.