=COUNTIF(C1:C6,"Y")

Try the formula above in C7

"dread" wrote:

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!