View Single Post
  #3   Report Post  
Al
 
Posts: n/a
Default

So What is supposed to go in the quotes?

"Bob Phillips" wrote:

=SUMPRODUCT(--(INDEX("'"&A2&"'!$B$2:$B$12000")=D2),--(INDEX("'"&A2&"'!$H$2:$
H$12000")="1"))