Help please

[Gixxer Lad]

Hi Clever Folk,
Forgive me if this has been previously been answered, I have had a look and cannot find anything that helps.

I have a worksheet where columns A, C, E, G, I & so on have list of names and B, D, F, H, J & so on have lists of numbers.
I am looking for a formula where it looks to match a particular name in the array and total the numbers that are in the cell immediately to the right, the name can appear in any of the name columns.

Any help is appreciated, unfortunately I cannot get my head around it.
Thanks in advance

 

[kweaver]

Please change your profile to reflect the version of Excel you are using and illustrate some sample data and expected results using XL2BB.

 

[Peter_SSs]

See if something like this could work for you. If not, refer to post #2.

23 07 12.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1										Name	Amount
2	a	5	f	7	k	2	r	6		m	3
3	b	4	g	6	l	6	s	1		a	12
4	c	1	h	3	m	3	a	7
5	d	8	i	4	n	9
6	e	9	j	3	o	5
7					p	5
8					q	7
9
10
Gixxer Lad

Cell Formulas
Range	Formula
K2:K3	K2	=SUMIF(A$2:G$10,J2,B$2:H$10)

 

[Gixxer Lad]

Absolutely wonderful, thank you.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.
.. and for updating your version info.