date formula errors

F

floridasurfn

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)))
 
M

Max

floridasurfn said:
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)))
Click to expand...

I got this slight amendment to work (array-entered):
=MAX(IF(INDIRECT("CLIENT!I2:I"&$O$1)="HOMESIDE",INDIRECT("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"
 
Top