how to sum items in a column if there exists some more refernces
 

I have order numbers in one column, items in another and amount in another.
The sheet is prepared according to the item. But, I would like to calculate
what is the amount for each order.
I could do it with the help of Pivot, but i hav some more fields required
like this and i am unable to do that through pivot. Is there any way I can
use?

how to sum items in a column if there exists some more refernces
 

Hi,

Not sure I understand but with your data

Order numbers in column A,
items in Column B
Amount in column C
Order number to search for in D1 try:-

=SUMPRODUCT((A1:A100=D1)*(C1:C100))

This will sum column c for every occurence of order number in column A

Mike


"Dileep" wrote:

I have order numbers in one column, items in another and amount in another.
The sheet is prepared according to the item. But, I would like to calculate
what is the amount for each order.
I could do it with the help of Pivot, but i hav some more fields required
like this and i am unable to do that through pivot. Is there any way I can
use?