If you wish to use SUMPRODUCT you need to ensure that all relevant terms are
included within the parameters of the SUMPRODUCT function. Look again at
your parentheses and see where your SUMPRODUCT function ends.

Try
=SUMPRODUCT(('Detail Hours'!A1:A60000=A9)*('Detail
Hours'!A1:A60000<"")*('Detail Hours'!H1:H60000))
or
=SUMPRODUCT(--('Detail Hours'!A1:A60000=A9),--('Detail
Hours'!A1:A60000<""),('Detail Hours'!H1:H60000))
--
David Biddulph

ColleenK wrote:
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