Thread: Help with SUMPRODUCT formula !!!!!!!!!!!!!!!!!!!!!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ayo Ayo is offline
external usenet poster
  
Posts: 489
Default 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
Reply With QuoteReply With Quote