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

G

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to ignore a column of numbers in Grand Total for rows 1
SUM - IF - AND 7
How to Show SUM of field value in other column 4
Subtotals in a Pivot Table 1
Sum of items in a column if they meet two criteria in another colu 6
Time Sum in Excel 1
Wrong sum value after calculate with Percentage 10
use month in cell date to sum all relevant cells 2

Top