Hi There,

I am new to using the sumproduct formula, would someone be able to tell me
why the following is not working:

=SUMPRODUCT('Detail Hours'!A1:A60000=A9)*('Detail
Hours'!A1:A60000<"")*('Detail Hours'!H1:H60000)

Thanks
--
CK