tricky lookup formula

[chalmun]

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.

 

[Mudface]

A pivot table should be ideal for this.

 

[chalmun]

um, yeah, how might i do that?

 

[Aladin Akyurek]

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]

Book2
	A	B	C	D
1	a	2	a	7
2	b	3	b	9
3	c	4	c	7
4	a	5
5	b	6
6	c	3
Sheet1

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

 

[Aladin Akyurek]

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]

Thanks SIR I Fully Agree.

One of your disciple

GNaga

 

[chalmun]

hey thanks guys