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

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
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.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
Thanks SIR I Fully Agree.

One of your disciple

GNaga
 
Upvote 0

Forum statistics

Threads
1,213,511
Messages
6,114,054
Members
448,543
Latest member
MartinLarkin

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
Back
Top