Counting the number of "Y" in a row

's Computer Specifications

Hi all

I know this has to be pretty simple but I can't quite figure it out. I
want a field at the end of each row which will count the number of
fields with a "Y" and show the total number. I tried an IF statement
but this went all wrong and I have tried the COUNT () statement but
was not sure how to get this to count letters.

Can somebody please help?

's Computer Specifications

Have a look in the help index for COUNTA

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Mikey C" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi all
>
> I know this has to be pretty simple but I can't quite figure it out. I
> want a field at the end of each row which will count the number of
> fields with a "Y" and show the total number. I tried an IF statement
> but this went all wrong and I have tried the COUNT () statement but
> was not sure how to get this to count letters.
>
> Can somebody please help?
>

's Computer Specifications

Typo alert

Not COUNTA but COUNTIF

=COUNTIF(A1:A25,"Y")

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Don Guillett" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Have a look in the help index for COUNTA
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "Mikey C" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi all
>>
>> I know this has to be pretty simple but I can't quite figure it out. I
>> want a field at the end of each row which will count the number of
>> fields with a "Y" and show the total number. I tried an IF statement
>> but this went all wrong and I have tried the COUNT () statement but
>> was not sure how to get this to count letters.
>>
>> Can somebody please help?
>>
>
>

's Computer Specifications

Thanks Ron. Too early for an old man I guess.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Ron de Bruin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Typo alert
>
> Not COUNTA but COUNTIF
>
> =COUNTIF(A1:A25,"Y")
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Have a look in the help index for COUNTA
>>
>> --
>> Don Guillett
>> SalesAid Software
>> (E-Mail Removed)
>> "Mikey C" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Hi all
>>>
>>> I know this has to be pretty simple but I can't quite figure it out. I
>>> want a field at the end of each row which will count the number of
>>> fields with a "Y" and show the total number. I tried an IF statement
>>> but this went all wrong and I have tried the COUNT () statement but
>>> was not sure how to get this to count letters.
>>>
>>> Can somebody please help?
>>>
>>

's Computer Specifications

Cool - thanks Don and Ron! Much appreciated

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access Query "Show number 0 if no records are selected by counting"	johan	Microsoft Access	2	28th Jun 2008 01:13 PM
Counting number of times "A" appears in a table column	pauladeanda@gmail.com	Microsoft Access	7	3rd Jun 2008 08:32 PM
counting the number of times value of "x" appears in a row	=?Utf-8?B?SHVnaA==?=	Microsoft Excel Misc	2	2nd Aug 2006 12:17 PM
Counting the number of "True" values in a boolean column.	=?Utf-8?B?TW9ua2V5X08=?=	Microsoft Access Reports	3	13th Jul 2006 04:01 PM
COUNT: Counting the number of times "X" comes up after the occurrence of "Y"	DrSues02	Microsoft Excel Misc	5	3rd Aug 2004 06:35 AM