=COUNTA(D122,"=A27")

In the above formula I believe I am counting the number of instances the
name in A27 appears in the list from D1 to D22.

In the actual list the name in A27 actually only appears once, but the
formula is telling me it appears 23 times.

I think I am not doing something right.

Please help

Hi,

Your formula is counting non-blank cells in the range 'and' A27 hence the
answer 23

try this

=COUNTIF(D122,"="&A27)

Mike

"Jeremy" wrote:

> =COUNTA(D122,"=A27")
>
> In the above formula I believe I am counting the number of instances the
> name in A27 appears in the list from D1 to D22.
>
> In the actual list the name in A27 actually only appears once, but the
> formula is telling me it appears 23 times.
>
> I think I am not doing something right.
>
> Please help

You are correct. You are not doing something right.
Try looking up the function COUNTA in Excel help.
You may also wish to look up the function COUNTIF.
--
David Biddulph

"Jeremy" <jeremiah.a.reynolds @ gmail.com> wrote in message
news:4F83E601-7586-423A-8A19-(E-Mail Removed)...
> =COUNTA(D122,"=A27")
>
> In the above formula I believe I am counting the number of instances the
> name in A27 appears in the list from D1 to D22.
>
> In the actual list the name in A27 actually only appears once, but the
> formula is telling me it appears 23 times.
>
> I think I am not doing something right.
>
> Please help

That worked beautifully, now if you coule teach me to fish for one second.

I get the fisrt part of the equation. It's the ,"="&A27 part that I don't
understand. What is this telling the computer to do?

Thanks, I want to learn this so one day I can help people too!

"Mike H" wrote:

> Hi,
>
> Your formula is counting non-blank cells in the range 'and' A27 hence the
> answer 23
>
> try this
>
> =COUNTIF(D122,"="&A27)
>
> Mike
>
> "Jeremy" wrote:
>
> > =COUNTA(D122,"=A27")
> >
> > In the above formula I believe I am counting the number of instances the
> > name in A27 appears in the list from D1 to D22.
> >
> > In the actual list the name in A27 actually only appears once, but the
> > formula is telling me it appears 23 times.
> >
> > I think I am not doing something right.
> >
> > Please help

Hi,

It tells excel to look at the address A27. If you put the entire thing in
quotes
"=A27" then excel treats that as a literal string instead of an address.

It's no different to using the concatenate sign (&) in a cell.

Mike


"Jeremy" wrote:

> That worked beautifully, now if you coule teach me to fish for one second.
>
> I get the fisrt part of the equation. It's the ,"="&A27 part that I don't
> understand. What is this telling the computer to do?
>
> Thanks, I want to learn this so one day I can help people too!
>
> "Mike H" wrote:
>
> > Hi,
> >
> > Your formula is counting non-blank cells in the range 'and' A27 hence the
> > answer 23
> >
> > try this
> >
> > =COUNTIF(D122,"="&A27)
> >
> > Mike
> >
> > "Jeremy" wrote:
> >
> > > =COUNTA(D122,"=A27")
> > >
> > > In the above formula I believe I am counting the number of instances the
> > > name in A27 appears in the list from D1 to D22.
> > >
> > > In the actual list the name in A27 actually only appears once, but the
> > > formula is telling me it appears 23 times.
> > >
> > > I think I am not doing something right.
> > >
> > > Please help

You can get away with just =COUNTIF(D122,A27)

As for learning to fish, as I suggested in another message on this thread,
use Excel help for the COUNTIF function.
--
David Biddulph

"Jeremy" <jeremiah.a.reynolds @ gmail.com> wrote in message
news07492FC-9507-47CC-980B-(E-Mail Removed)...
> That worked beautifully, now if you coule teach me to fish for one second.
>
> I get the fisrt part of the equation. It's the ,"="&A27 part that I don't
> understand. What is this telling the computer to do?
>
> Thanks, I want to learn this so one day I can help people too!
>
> "Mike H" wrote:
>
>> Hi,
>>
>> Your formula is counting non-blank cells in the range 'and' A27 hence the
>> answer 23
>>
>> try this
>>
>> =COUNTIF(D122,"="&A27)
>>
>> Mike
>>
>> "Jeremy" wrote:
>>
>> > =COUNTA(D122,"=A27")
>> >
>> > In the above formula I believe I am counting the number of instances
>> > the
>> > name in A27 appears in the list from D1 to D22.
>> >
>> > In the actual list the name in A27 actually only appears once, but the
>> > formula is telling me it appears 23 times.
>> >
>> > I think I am not doing something right.
>> >
>> > Please help