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

L

learning

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.
 
P

Peo Sjoblom

=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
 
L

learning

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


Peo Sjoblom said:
=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
Click to expand...
 
Top