SUMPRODUCT

C

ColleenK

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
 
D

David Biddulph

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))
 
C

ColleenK

Thank you very much for the solution, quick question I have never see the
dashes in a statement, what does it represent?
 

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

Top