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? |
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 |