Sum multiple nested loop entries

Hi guys,

I am trying to extract data from one sheet which contains multiple entries (sheet 2) into another sheet which will condense these entries into a single row (sheet1).

The relevant rows in sheet 2 are selected with a nested loop based on the group (col. A) and region (col. B) in sheet 1.

My problem: once the appropriate rows are identified in sheet 2, how do i produce their sum in sheet 1?

I have attached a sample book, highlighted in yellow (pallet permitting) the matching columns in sheet 2 that I would like to extract into sheet 1.

Please Login or Register  to view this content.

Thanks for your time and help!
D

Originally Posted by pike

Hi dems
try using a pivot table

That would be ideal, but in the full version I am r.ipping this data from several different books.