Prev: 'Save As' hangs Excel XP 2002 SP3
Next: clear inputs macro
From: Ayo on 26 Apr 2010 14:51
=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
From: Dave Peterson on 26 Apr 2010 14:56
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
From: Paul C on 26 Apr 2010 15:02
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
 | 
Pages: 1
Prev: 'Save As' hangs Excel XP 2002 SP3
Next: clear inputs macro