View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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