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" wrote in message
...
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....