dread

What about

=COUNTIF(C1:C6,"=Y")

Dave
"dread" wrote in message
...
I have several columns that will contain either a "Y" or "N". I want to
check the columns to see if there is more than one "Y". How can I do this?
Is it possible to combine AND with OR in an IF statement, and how is it
done?

C1 = Y
C2 = N
C3 = N
C4 = Y
C5 = Y
C6 = N

In C7 I want to check C1 thru C6 and indicate that there are 3 "Y"'s in
these columns.

Thanks for the help!