Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Discussion (Misc queries) | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
hlp with sumproduct! | Excel Worksheet Functions | |||
sumproduct help | Excel Worksheet Functions |