SUMPRODUCT

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT 3
Timesheet formula help 2
SUMPRODUCT ERROR 8
SUMPRODUCT QUERY 1
My calendar keeps returning to working hours of 08:00h to 17:00h even after I set it to 24h? 1
Sumproduct using multiple sheets 0
SUMPRODUCT - Count Various criteria in same column (exclude other) 8
Sumproduct formula needed 2

Top