Jerry,

Here is a variation that caters for the -

=INDEX(B2:D2,1,MAX(IF(ISBLANK(B2:D2),0,IF(B2:D2="-",0,COLUMN(B2:D2)-1))))

I am not sure what you mean by the extra columns.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jerry" <nosoup4yew@yahoo.com> wrote in message
news:1133455753.501219.289960@g49g2000cwa.googlegroups.com...
> Thanks for your reply. I could not get your solution to work for me
> though. Here's a little more info on what I'm looking to do:
>
> First, the equation I'm using with very limited success:
> =IF((AND(C3<>0,D3<>0,E3<>0)),E3,(IF(AND(C3<>0,D3<>0),D3,C3)))
>
> The spreadsheet setup:
> A B C D E
> 1 Est1 Est2 Act Total
> 2 Alpha 5.00 10.00 12.00 12.00
> 3 Beta 5.00 11.00 5.00
> 4 Gamma 10.00 11.00 -
> 5 Delta 10.00 -
>
>
>
>
> As you can see, the above equation only yields the correct Total in the
> Alpha row because all the fields have a value. In my actual
> spreadsheet there are 3 additional columns between the "Act" and "Rptd"
> that should not be counted in my equation, but if you use an array
> formula, would proabably have to be included. I'm not really familiar
> with arrays, so if you have any advice, I'd really appreciate it.
>