Thanks for the reply
I get a #value when I use your formula. :-(
"Bob Phillips" wrote:
=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
|