assuming the last one should be 2 not 4

=COUNTIF(A2:E2,"Off")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"SteveC" <SteveC@discussions.microsoft.com> wrote in message
news:EB82CBD5-257E-4AC8-B982-1227FE3FF61A@microsoft.com...
> This works great: In Cell G2: =MATCH("Off",A4:E4,0)-1
>
> ColA ColB ColC ColD ColE
> ColG
> Apples Apples Off Apples Off 2
> Bannanas Bannanas Bannanas Bannanas Off 4
> Coyotes Coyotes Coyotes Off Off 3
> Elephants Elephants Elephants Elephants Off 4
>
>
> Now someone please tell me what formula would work in ColG in the set
below,
> with ColG referencing ColA? If possible?
>
> ColA ColB ColC ColD ColE
> ColG
> Apples Off Coyotes Apples Off 2
> Bannanas Apples Elephants Bannanas Off 1
> Coyotes Coyotes Off Off Off 3
> Elephants Elephants Off Elephants Off 4
>
> just curious if this is possible... thanks....
>
>
>
>