Collect weight and quantity from list

[barissh]

I have a list such as herebelow format. Each GID line shows quantity and MEA shows weight. I need a macro to get total of each quantity and weight. As you see quantity and wegiht are not in a specific digit but variable.

LIST:
GID;1;190;BI;
MEA;KGM;20750.50;
GID;2;1000;BI;
MEA;KGM;22400;
GID;3;10;BI;
MEA;KGM;2450;

TOTAL:
GID = 1200 ( 190 + 1000 + 10 )
MEA = 45600,50 ( 20750.50 + 22400 + 2450 )

 

[T. Valko]

I have a list such as herebelow format. Each GID line shows quantity and MEA shows weight. I need a macro to get total of each quantity and weight. As you see quantity and wegiht are not in a specific digit but variable.

LIST:
GID;1;190;BI;
MEA;KGM;20750.50;
GID;2;1000;BI;
MEA;KGM;22400;
GID;3;10;BI;
MEA;KGM;2450;

TOTAL:
GID = 1200 ( 190 + 1000 + 10 )
MEA = 45600,50 ( 20750.50 + 22400 + 2450 )

Is the data in separate columns like this:

Book1
	A	B	C	D
2	GID	1	190	BI
3	MEA	KGM	20750.5	_
4	GID	2	1000	BI
5	MEA	KGM	22400	_
6	GID	3	10	BI
7	MEA	KGM	2450	_
Sheet1

If so, then:

Book1
	A	B	C	D	E	F	G
2	GID	1	190	BI	_	GID	1200
3	MEA	KGM	20750.5	_	_	MEA	45600.5
4	GID	2	1000	BI	_	_	_
5	MEA	KGM	22400	_	_	_	_
6	GID	3	10	BI	_	_	_
7	MEA	KGM	2450	_	_	_	_
Sheet1

This formula entered in G2 and copied down:

=SUMIF(A$2:A$7,F2,C$2:C$7)

 

[barissh]

Dear Valko,

Thanks for your suggestion but I should solve this problem without converting text to columns.

 

[Peter_SSs]

See if this helps.

Excel Workbook
	A	B	C	D
2	GID;1;190;BI;		GID	1200
3	MEA;KGM;20750.50;		MEA	45600.5
4	GID;2;1000;BI;
5	MEA;KGM;22400;
6	GID;3;10;BI;
7	MEA;KGM;2450;
Sum