This does not work it gives me a true statement and it counted a "N" as true.

What I need is for it to count or sum a total in number format of the "Y" in
the non-consecutive columns. That column could be a Y or N and I need to
count the Y in non-consecutive columns across a spreadsheet.

Thanks!

"Brad" wrote:

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!