Just to explain that function if looks at C1 to C6 and if there is a Y it
counts the number of Y's.
Further to your 1st question yes you can do ORs and ANDs with IF's if you
have to. (In this instance the COUNTIF function works best though)


"dread" wrote:

Wow that was too easy! Thank you very much!!!

"tim m" wrote:

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