brindha_shree
New Member
- Joined
- Sep 23, 2002
- Messages
- 23
Hello,
The data below is each in different worksheet (where by the both data never should be all under one sheet)
I need to sum the savings according to the description.How can I do this?
One code could have more than one savings, example code 3060 have 2 savings. Then the one description
should have more than one code.I know how to sum the savings according to the code but I don’t know how to sum
the savings according to it's description.Is there anyone can help me?The data range is more than 25000 savings,
around 80 code and 15 description. Please help, I am a student doing my training. I need to submit this task soon.
Please Help. (the table above will be in diff sheets, the data cannot be mixed)
Regards,
Brindha
CODE SAVINGS
1245 833.69
1247 12217.84
1248 1211917
1249 119240.94
3030 904910.97
3040 4556.52
3050 185524.9
3060 514246.95
5001 354097.33
5003 624498.97
5015 796350
1245 132.85
3060 324.98
3060 2341.65
1248 2412
1247 12414
In other worksheet, this is the data
CODE Description
1245 equipment
1247 equipment
1248 equipment
1249 equipment
3030 Substrates
3040 Substrates
3050 Substrates
3060 Substrates
5001 Chemicals
5003 Chemicals
5015 Chemicals
The data below is each in different worksheet (where by the both data never should be all under one sheet)
I need to sum the savings according to the description.How can I do this?
One code could have more than one savings, example code 3060 have 2 savings. Then the one description
should have more than one code.I know how to sum the savings according to the code but I don’t know how to sum
the savings according to it's description.Is there anyone can help me?The data range is more than 25000 savings,
around 80 code and 15 description. Please help, I am a student doing my training. I need to submit this task soon.
Please Help. (the table above will be in diff sheets, the data cannot be mixed)
Regards,
Brindha
CODE SAVINGS
1245 833.69
1247 12217.84
1248 1211917
1249 119240.94
3030 904910.97
3040 4556.52
3050 185524.9
3060 514246.95
5001 354097.33
5003 624498.97
5015 796350
1245 132.85
3060 324.98
3060 2341.65
1248 2412
1247 12414
In other worksheet, this is the data
CODE Description
1245 equipment
1247 equipment
1248 equipment
1249 equipment
3030 Substrates
3040 Substrates
3050 Substrates
3060 Substrates
5001 Chemicals
5003 Chemicals
5015 Chemicals