| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The amount calculated based on two entry criteria (somproduct?)
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
The amount calculated based on two entry criteria (somproduct?)
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 "The Fool on the Hill" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the last entry in a column based on criteria | Excel Worksheet Functions | |||
| How do I get a calculated amount to round to the nearest nickel? | Excel Worksheet Functions | |||
| random number entry based on two criteria | Excel Discussion (Misc queries) | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| sumif-add amount to another cell based on two criteria | Excel Discussion (Misc queries) | |||
Linear Mode
