Try the array formula:

=SUM((C2:C7000="Friday")*(F2:F7000=TIME(8,0,0)))

Or, this non-array version:

=SUMPRODUCT(--(C2:C7000="Friday"),--(F2:F7000=TIME(8,0,0)))

--
Biff
Microsoft Excel MVP


"chubbybat" wrote in message
...
HI there,

I am so close but this will not add any values.
I do ctrl shift enter and it accepts the formula but I only get a 0.
Any ideas? Time cell is formatted as time and Friday is formatted as
General.