Lookup Question

  • Thread starter Thread starter JackTaylor
  • Start date Start date
J

JackTaylor

I have a range of A1 through B45. Column A contains
various item descriptions and column B the quantity
needed of each item. Several items through out column A
are the same.

I want to find all items in column A that are the same,
look at the quantities in column B, add the quantities
together and plnce the total in cell C1.

Is this a Lookup function and, if so, can anyone suggest
the appropriate string to get the result?

Thanks!

JT
 
Hi Jack,

One way of accomplishing what you want is by using Sumproduct. Try the
following:

=SUMPRODUCT(--(A1:A45="name-of-item"),B1:B45)

Hope this helps!
 
Back
Top