"floridasurfn" wrote:
i have this formula that i am using as an array , but it gives me an error
message. i am trying to use the formula on a page called "calculations".. the
information being used is on a page called "client" .. i am also indirectly
referencing a cell "O1" on the calculations page so that i dont have to
change the formulas all the time.. can someone tell me why this doesnt work??

=MAX(IF(INDIRECT("CLIENT!$I$2:$I"&$O$1)="HOMESIDE" ),(INDIRECT("CLIENT!$E$2:$E"&$O$1)))

I got this slight amendment to work (array-entered):
=MAX(IF(INDIRECT("CLIENT!I2:I"&$O$1)="HOMESIDE",IN DIRECT("CLIENT!E2:E"&$O$1)))

Probably the issue was with the extra parens: .. ="HOMESIDE")

I've also removed some unnecess "$" signs within the text string in
INDIRECT, eg within: "CLIENT!$I$2:$I"

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---