If I understand the problem correctly, in addition to any other
summations on the Summary sheet, you want the most recent week's sales
listed.

Here's the solution I came up with. It is clumsier than I like;
hopefully someone will be along to clean it up.

In the Company A sheet, we have something like this:

Sales
Week 1 11000
Week 2 15000
Week 3 22000

In the Summary sheet, I put "Week 3" in cell A1, and in cell A2 put the
following formula:

=SUMPRODUCT(('Company A'!A2:A100='Summary'!A1)*('Company A'!B2:B100))

It is clunky, in that you have to manually enter "Week 3", or whatever
week, in cell A1 to get the result. Hopefully, though, this will get
us started toward a solution.


--
Teodomiro


------------------------------------------------------------------------
Teodomiro's Profile: http://www.excelforum.com/member.php...o&userid=33140
View this thread: http://www.excelforum.com/showthread...hreadid=530708