So all the quotes on either side of the & symbols are for what?

"Bob Phillips" wrote:

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"))