To help you further I would need to see a simplifed set of data and what
your pivot table was analysing. I would then suggest how to use the
sumproduct table. To save time you can e-mail the simplified
spreadsheet to , as I don't visit the forum
every day.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=569780