Hi,

Am Wed, 30 Oct 2013 00:03:15 +0000 schrieb vabulous:

=SUMPRODUCT(SUMIF(INDIRECT({"1","2","3","4","5"... "31"}&"$A$5:$A$100"),C1,INDIRECT({1","2","3","4"," 5"..."31"}&"!$C$5:$C$100")))/3600

Where A:A is name column on each date tab wksht (name appears regardless
if data is present), C1 is on Summary tab and holds name and C:C
provides numeric data (seconds) on each date tab wksht...formula is on
Summary tab...

try:
=SUMPRODUCT(SUMIF(INDIRECT(ROW(1:31)&"!A5:A100"),C 1,INDIRECT(ROW(1:31)&"!C5:C100")))/3600


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2