Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with SUMPRODUCT formula !!!!!!!!!!!!!!!!!!!!!
=SUMPRODUCT(('Sites Task List_Logical'!$B$2:$B$5776=$C26)*('Sites Task
List_Logical'!$Q$2:$Q$5776=FALSE)) =SUMPRODUCT(('Sites Task List_Logical'!$B$2:$B$5776=$C26)*('Sites Task List_Logical'!$Q$2:$Q$5776="FALSE")) why are the above formulae giving me a "#VALUE!" error |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with SUMPRODUCT formula !!!!!!!!!!!!!!!!!!!!!
Maybe you have a #value! error in B2:b5776 or q2:a5776 of the "sites task
list_logical" sheet? Or that error in C26 in the activesheet? Ayo wrote: =SUMPRODUCT(('Sites Task List_Logical'!$B$2:$B$5776=$C26)*('Sites Task List_Logical'!$Q$2:$Q$5776=FALSE)) =SUMPRODUCT(('Sites Task List_Logical'!$B$2:$B$5776=$C26)*('Sites Task List_Logical'!$Q$2:$Q$5776="FALSE")) why are the above formulae giving me a "#VALUE!" error -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with SUMPRODUCT formula !!!!!!!!!!!!!!!!!!!!!
The first formula looks ok. The most likely culprit is a cell in your range
is evaluating to #VALUE!. Use the autofilter or error checking to check your data. It only takes 1 errored celle to cuse SUMPRODUCT to error out The second formula would be used only if Column Q contains FALSE as a text string -- If this helps, please remember to click yes. "Ayo" wrote: =SUMPRODUCT(('Sites Task List_Logical'!$B$2:$B$5776=$C26)*('Sites Task List_Logical'!$Q$2:$Q$5776=FALSE)) =SUMPRODUCT(('Sites Task List_Logical'!$B$2:$B$5776=$C26)*('Sites Task List_Logical'!$Q$2:$Q$5776="FALSE")) why are the above formulae giving me a "#VALUE!" error |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
sumproduct formula | Excel Worksheet Functions | |||
Sumproduct or Other Formula? | Excel Worksheet Functions | |||
sumproduct formula | Excel Worksheet Functions | |||
SUMPRODUCT formula | Excel Worksheet Functions |