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