Let us assume that each sheet has only 2 columns, col A = product and
col B = sales.

in the summary sheet, try this

=sumproduct((sheet2!$a$2:$a$10000="toys")*(sheet2! $b$2:$b$10000))+sumproduct((sheet3!$a$2:$a$10000=" toys")*(sheet3!$b$2:$b$10000))+sumproduct((sheet4! $a$2:$a$10000="toys")*(sheet4!$b$2:$b$10000))

this will give you total sales for toys from all sheets, on subsequent
rows in your summary sheet substitute "tools", "radios" etc etc


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