Thread: The amount calculated based on two entry criteria (somproduct?)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Fool on the Hill The Fool on the Hill is offline
external usenet poster
  
Posts: 58
Default 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?

Reply With QuoteReply With Quote