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