tricky lookup formula

chalmun

New Member
Joined
Oct 17, 2002
Messages
4
i have a list of items in column A and a list of numbers in column B. the item names repeat. i need a formula that will seek out and add up the numbers for the corresponding item names.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
On 2002-10-18 04:04, chalmun wrote:
i have a list of items in column A and a list of numbers in column B. the item names repeat. i need a formula that will seek out and add up the numbers for the corresponding item names.

=SUMIF(A-range,Item,B-range)

would also work.
 

gnaga

Well-known Member
Joined
Jul 9, 2002
Messages
742
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
Book2
ABCD
1a2a7
2b3b9
3c4c7
4a5
5b6
6c3
Sheet1

Sumproduct formula also can be used for your task
This message was edited by gnaga on 2002-10-18 04:43
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
On 2002-10-18 04:41, gnaga wrote:

[...]

Sumproduct formula also can be used for your task

When SUMIF can do the required computation, SUMPRODUCT is unnecessary. Moreover, the former computes faster and costs less.
 

gnaga

Well-known Member
Joined
Jul 9, 2002
Messages
742
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
Thanks SIR I Fully Agree.

One of your disciple

GNaga
 

Forum statistics

Threads
1,181,446
Messages
5,929,965
Members
436,709
Latest member
cbmxd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top