SUMPRODUCT

  • Thread starter Thread starter ColleenK
  • Start date Start date
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
 
Thank you very much for the solution, quick question I have never see the
dashes in a statement, what does it represent?
 
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 QUERY 1
SUMPRODUCT ERROR 8
SUMPRODUCT - Count Various criteria in same column (exclude other) 8
Sumproduct formula needed 2
How to change a formula in one cell and have these changes appear 3
using sumproduct 2
sumproduct of multiple sheets 5
SUMPRODUCT 6

Back
Top