Assuming the Overnight tab columns are in A:D

In the summary sheet

=SUMPRODUCT((C1:C1000="S4 Test")*D1:D1000)

Just change the ="S4 Test" to ="S3 Test" for that total.

or you can use SUMIF

=SUMIF(C1:C1000,"S4 Test",D1:D1000)

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=544361