=SUMPRODUCT(--(TRANSMISSION!$C$6:$IV$6="Foo")*(--(TRANSMISSION!$C$18:$IV$18=
"Boo"))*(INDIRECT("TRANSMISSION!$C$"&A1+18&":$IV$" &A1+18)))

--

HTH

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


"Sandy" wrote in message
...
Hi
I need to use INDIRECT but Im not sure how....

=SUMPRODUCT(--(TRANSMISSION!$C$6:$IV$6="Foo")*(--(TRANSMISSION!$C$18:$IV$18=
"Boo"))*(TRANSMISSION!$C$32:$IV$32))

The 32 is the value of row(A1)+18

Thanks