The amount calculated based on two entry criteria (somproduct?)

  • Thread starter The Fool on the Hill
  • Start date
T

The Fool on the Hill

I have a financial list with financial data.

In column A I have Names (this can be 5 different entries)
In column B I have materials (This can be 5 differnet entries)
In column C I have an amount

This concerns a department selling materials. Now, what I am looking for is
the following:How much is the amount of the materials sold per name.

Can you please help me?
 
M

Mike H

Hi,

Sumproduct will do that
=SUMPRODUCT((A1:A20=D1)*(B1:B20=E1)*(C1:C20))

With your name to search for in D1
Product in E1

Mike
 
Top