Sum from multiple columns

[aliaslamy2k]

Dear Experts,

Please help me with a formula to get the total of each countries from multiple columns.

Example Lebanon : 50 + 216+192
Kyrgystan : 50 + 20

 

[alansidman]

Cannot manipulate data in a picture. Please reload your data sample using XL2BB

 

[aliaslamy2k]

Dear Alansidman.

Please find below, as requested. Thank you so much

Assigned Countries		Total Assigned		Assigned Countries		Total Assigned		Assigned Countries		Total Assigned		Assigned Countries		Total Assigned		Assigned Countries		Total Assigned			Tunisia	361
India	95	232		Lebanon	50	100		Lebanon	216	236		Lebanon	192	219		Russia	90	90			India	0
Sri Lanka	102			Kyrgystan	50			Kyrgystan	20			Spain	27								Sri Lanka	#REF!
Kenya	35																				Kenya
																					Lebanon
																					Kyrgystan
																					Spain
																					Russia

 

[Peter_SSs]

Firstly, I suggest that you update your Account details or your signature or both as this is quite confusing.

Does this do what you want?

22 06 13.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Assigned Countries		Total Assigned		Assigned Countries		Total Assigned		Assigned Countries		Total Assigned		Assigned Countries		Total Assigned		Assigned Countries		Total Assigned			Tunisia	0
2	India	95	232		Lebanon	50	100		Lebanon	216	236		Lebanon	192	219		Russia	90	90			India	95
3	Sri Lanka	102			Kyrgystan	50			Kyrgystan	20			Spain	27								Sri Lanka	102
4	Kenya	35																				Kenya	35
5																						Lebanon	458
6																						Kyrgystan	70
7																						Spain	27
8																						Russia	90
Country totals

Cell Formulas
Range	Formula
W1:W8	W1	=SUMIF(A$2:Q$4,V1,B$2:R$4)

 

[aliaslamy2k]

Dear Peter,

I have updated my account. Thank you so much for giving me perfect formula. Its working absolutely fine.

Thank you once again

Firstly, I suggest that you update your Account details or your signature or both as this is quite confusing.

View attachment 66928 View attachment 66929

Does this do what you want?

22 06 13.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Assigned Countries		Total Assigned		Assigned Countries		Total Assigned		Assigned Countries		Total Assigned		Assigned Countries		Total Assigned		Assigned Countries		Total Assigned			Tunisia	0
2	India	95	232		Lebanon	50	100		Lebanon	216	236		Lebanon	192	219		Russia	90	90			India	95
3	Sri Lanka	102			Kyrgystan	50			Kyrgystan	20			Spain	27								Sri Lanka	102
4	Kenya	35																				Kenya	35
5																						Lebanon	458
6																						Kyrgystan	70
7																						Spain	27
8																						Russia	90
Country totals

Cell Formulas
Range	Formula
W1:W8	W1	=SUMIF(A$2:Q$4,V1,B$2:R$4)

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

.. and for fixing those account details.