I think I'd use a Pivot Table for that.

Select the data range
DataPivot Table
--Select Excel range....click[Next]
--Make sure the range is correct.... click [Next]
--Select either New Worksheet or Existing Worksheet
--Click the [Layout...] button
----ROWs: Clients, Products
----DATA: Sum of Qtr, Sum of Total....Click [OK]
Click [Finish]

Is that something you can work with?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=395006