View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

As given, This assumes the dd is in A2, and will pick up its value.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Al" wrote in message
...
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"))