Analysis of Amount based on following criterion.

[aligahk06]

Dear All,

i want to analyse me data as per requirment.
The Attached file is a sample.
As per our client requirement the data analysis is as follows.
Based on Plant say LAO
Remove Cladding total Amount
Remove Insulation Total Amount
New Cladding Total Amount
New Insulation Total Amount
Reinstall Cladding Total Amount
Reinstall Insulation Total Amount
Then total ( All above six job ) for Plant Lao.
The same for all rest of the Plant i.e Col B.

Note:- I have applied sort techniques for each plant but it is tedious and time taken job.
So Im looking best way to achieve this task.


Any help.

Rgds,
Aligahk06

[mdmackillop]

Here's a SumProduct method using dynamic ranges and data validation

[aligahk06]

Dear MdMackillop,

Could you plz elaborate why is my attachment not appearing in your reply.
Any suggestion ?

Rgds,
Aligahk06

[mdmackillop]

Are you not seeing an attachment in my post? I can see it and download it.

[aligahk06]

Dear Mdmackilopp,

Good solution. Plz let us know the step how did u do this ?
As i could not understand the steps involved in accomplishing the task.

Rgds,
aligahk06

[mdmackillop]

Sumproduct is a standard Excel function. You can read more about it here
The data in Plant, Job Description and Total Amount are referred to using Range Names . The Drop Downs use Data Validation. You can get information on each of these in Excel Help.

[aligahk06]

This thread is solved.

[aligahk06]

Dear All,

How to make a thread solved ? If the thread subscriber is satisfied with the solution.

[GTO]

Greetings aligahk06,

Look atop your first post in the thread for the 'Thread Tools' button. There is an option under the Thread Tools button to mark it Solved :-)

Mark