Function INDIRECT
Indeed you can
Simple example
=SUMPRODUCT(--(INDIRECT(A1)="x"))
where A1 holds B1:B20 for example
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"emilija" wrote in message
...
Can I use INDIRECT function nested with other function, for example with
SUMPRODUCT,
like : SUMPRODUCT(INDIRECT(..);INDIRECT(..))
I have tried but it doesn't work for me, am I wrong in syntax, or..
please write me an example which I can copy in workbook and see how it
works
TX
Emilija
|