SUMPRODUCT
 

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
--
CK

SUMPRODUCT
 

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

SUMPRODUCT
 

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


"David Biddulph" wrote:

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

SUMPRODUCT
 

http://www.mcgimpsey.com/excel/formulae/doubleneg.html
http://xldynamic.com/source/xld.SUMPRODUCT.html
--
David Biddulph

"ColleenK" wrote in message
...
Thank you very much for the solution, quick question I have never see the
dashes in a statement, what does it represent?
--
CK


"David Biddulph" wrote:

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