Lookup Question

[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

 

[Domenic]

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!

 

[Jack Taylor]

Dominic:

That worked incredibly well! Many thanks!

JT

 

[Domenic]

You're very welcome, Jack!

 

[Aladin Akyurek]

Wouldn't be less expensive to invoke a SumIf formula instead?