Need column evaluated to count total of occurrences of "Y". How?

I need to create a logic function to evaluate each cell in a specified range
to see if each cell contains "Y". If the cell contains "Y", then the number
"1" needs to be added to the running total. I want to know the total number
of "Y" in the column or specified range.

=COUNTIF(A:A,"Y")

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"learning" <[email protected]> wrote in message
news:[email protected]...
>I need to create a logic function to evaluate each cell in a specified
>range
> to see if each cell contains "Y". If the cell contains "Y", then the
> number
> "1" needs to be added to the running total. I want to know the total
> number
> of "Y" in the column or specified range.

Very kind of you to help out. I will try it.


"Peo Sjoblom" wrote:

> =COUNTIF(A:A,"Y")
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> "It is a good thing to follow the first law of holes;
> if you are in one stop digging." Lord Healey
>
>
> "learning" <[email protected]> wrote in message
> news:[email protected]...
> >I need to create a logic function to evaluate each cell in a specified
> >range
> > to see if each cell contains "Y". If the cell contains "Y", then the
> > number
> > "1" needs to be added to the running total. I want to know the total
> > number
> > of "Y" in the column or specified range.
>
>
>