date formula errors

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

floridasurfn - 21 Jun 2006 03:59 GMT

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

Reply to this Message

Max - 21 Jun 2006 04:29 GMT

> 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
[quoted text clipped - 3 lines]
>
> =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",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"

Signature

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

Reply to this Message