Count if or SumProduct

B

Brandy

I have two columns : column A defines the make/model; column B numerically
defines how many were sold . Note: There are multiple entries for the same
makes/models due to different territories.

I have a separate worksheet for which I need to summarize this info.
What would be the best formula for this task? I guess I am lost on what to
enter to count.

Any help is greatly appreciated!

Thank you,
 
M

Mike H

Hi,

Try this. The lookup value is in A1 of the currebt sheet

=SUMPRODUCT((Sheet1!A1:A20=A1)*(Sheet1!B1:B20))

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

Count if or Sum Product 5
how to count rows if 2 columns partially match 5
Sumproduct in matrix means 3
Help with Sumproduct searching cell contents 2
Nesting SUBTOTAL with SUMPRODUCT? 1
Count partial dates 1
Sumproduct & Count formula 8
Sumproduct with filters 7

Top