I would create a sumproduct table on each individual sheet and then
merely add the values in identical cells of the sumproduct table into
first of all the electrical and plumbing summaries and finally into one
overall summary.
Bob
--
bob777
------------------------------------------------------------------------
bob777's Profile:
http://www.excelforum.com/member.php...o&userid=28504
View this thread:
http://www.excelforum.com/showthread...hreadid=510988