C
ColleenK
Hi,
I am new to using the sumproduct formula, would someone be able to tell why
the following is not working:
=SUMPRODUCT('Detail Hours'!A1:A60000=A9)*('Detail
Hours'!A1:A60000<>"")*('Detail Hours'!H1:H60000)
Thanks
I am new to using the sumproduct formula, would someone be able to tell why
the following is not working:
=SUMPRODUCT('Detail Hours'!A1:A60000=A9)*('Detail
Hours'!A1:A60000<>"")*('Detail Hours'!H1:H60000)
Thanks