sum values in the same cells with another cells for multiple items

[abdelfattah]

hello
i no know what i ask for this is possible i have data in col a, b in a is item and b the values with contain symbol plus so i would sum every value in col b contain plus and with another value for the same item the result should in col e,f

f (1).xlsm
	A	B	C	D	E	F
1	NUMBER	AMOUNT			NUMBER	AMOUNT
2	65	200+100			65	700
3	66	100			66	1100
4	66	500			69	75
5	66	250+250			70	60
6	69	75			71	60
7	70	60			72	75
8	71	60			1000	35
9	72	50+25
10	65	100
11	65	200
12	1000	2+1+10+7+15
13			k
1

thanks

 

[JLGWhiz]

If you put an equal symbol in front of the values with a plus sign then you can use SUMIF to get the values in column F. See below.

TestBase.xlsm
	A	B	C	D	E	F
1	NUMBER	AMOUNT			NUMBER	AMOUNT
2	65	300			65	600
3	66	100			66	1100
4	66	500			69	75
5	66	500			70	60
6	69	75			71	60
7	70	60			72	75
8	71	60			1000	35
9	72	75
10	65	100
11	65	200
12	1000	35
Sheet1

Cell Formulas
Range	Formula
B2,B5,F2:F8,B9,B12	B2	=200+100

 

[abdelfattah]

hi, JLGWHIZ the formula should in col e, f not b the data stays in a,b whit out change when i sum it should keep data in b 65=200+100 not 300 is it possible ?

 

[JLGWhiz]

hi, JLGWHIZ the formula should in col e, f not b the data stays in a,b whit out change when i sum it should keep data in b 65=200+100 not 300 is it possible ?

There are no standard functions that would work with that type data but maybe one of the formula gurus will jump in and create one of those complex formulas with a bunch of IF conditions that would work. I am not that proficient with formulas to do that, so I will drop off this thread.
Regards, JLG

 

[abdelfattah]

any idea guys for what look for ?