Need to find a value and trigger process

[jamesstorx]

Hi There,

I have attached a sample of what I am working on. I have a CSV that is being imported into this workbook into the Consolidated sheet. I have a list of abbreviations on Sheet1. I want to find all "Par" in cosoldated and the determine the total are of each part. (Column A * Column B) and then continue on to the next abbreviation (SF).

Thanks for any help you can offer.
-James

[Leith Ross]

Hello jamesstorx,

Is there a reason for excluding column "C" - Part Thickness from the calculation?

[jamesstorx]

Hello jamesstorx,

Is there a reason for excluding column "C" - Part Thickness from the calculation?

the thickness of the parts is irrelevant to what I am trying to do. I am trying to determine total area so that I can get a total weight for all the parts combined.

[Leith Ross]

Hello jamesstorx,

So, just the sum of products in columns "A" and "B" for each product sales code, correct?

[jamesstorx]

Hello jamesstorx,

So, just the sum of products in columns "A" and "B" for each product sales code, correct?

I am going to multiply A by B to get the area and then multiply that by the Qty, then once that is done, add all that togeter to get a total area, which will be in Square Feet. this is way over my head... Thanks for you help.

[Leith Ross]

Hello jamesstorx,

Copy this formula into cell "D2" on "Sheet1" and drag it down.

=SUMPRODUCT(OFFSET(Consolidated!$A$1, 0, 0, COUNTA(Consolidated!$A:$A), 1),OFFSET(Consolidated!$B$1, 0, 0, COUNTA(Consolidated!$B:$B), 1), --(OFFSET(Consolidated!$D$1, 0, 0, COUNTA(Consolidated!$D:$D),1)=C2))