OK, so why is G3, looking for Bananas, only 1, not 2

--
HTH

Bob Phillips

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

"SteveC" <SteveC@discussions.microsoft.com> wrote in message
news:3842A90C-FA5B-4A91-9190-6627BEB4CD9C@microsoft.com...
> Hi, thanks for your response. Looks like that formula is counting "off",
but
> what I really want is to count whatever is in cell A2 in the range A2:E5,
> then return that value in G2. Then consecutively count whatever is in
cell
> A3 in the range A2:E5, and return that value in G3... etc... thanks very
> much for your time... regards, SteveC
>
> "Bob Phillips" wrote:
>
> > 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....
> > >
> > >
> > >
> > >
> >
> >
> >