Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count column if heading exists | Excel Discussion (Misc queries) | |||
Count data in one column if certain criteria exists in another. | Excel Worksheet Functions | |||
Determining if a value already exists in column(s) | Excel Discussion (Misc queries) | |||
Determine if Value in column A exists in Column B | Excel Discussion (Misc queries) | |||
Find if value in column A exists in Column B | Excel Worksheet Functions |