This is one way
=--(C2="Y")+--(E2="Y")+--(G2="Y")

added cells +--(I2="Y") as needed
--
Wag more, bark less


"shamor" wrote:

I have the following:
Attended Attended
A B C D E F
1 John Doe x Y x N ____

Column B and D with the x are if they are to attend and column C and E are
whether they attended or not and it continues for several other courses.

How do I sum or countif the nonconsecutive columns are Y? It will be column
C, E, G, I etc but the same row. I need to tally how many they actually
attended vs not attned in another column next to it.

Thank you! Hope this makes sense!