I have either a Y or N in cells based on two different things that happened
for the day (which explains why there are 7 COUNTIF statements, they all
pertain to a single day of the week).

What I am trying to do is to add up the number of days that EITHER one or
the other happened. I used the formula below:

=COUNTIF(C6:D6,"Y")+COUNTIF(F6:G6,"Y")+COUNTIF(I6: J6,"Y")+COUNTIF(L6:M6,"Y")+COUNTIF(O6:P6,"Y")+COUN TIF(R6:S6,"Y")+COUNTIF(U6:V6,"Y")&" / 7"

However, seeing as how I got a result of 8 / 7 for some days (in which on a
single day BOTH things happened), I realized the problem with the function,
as it is simply counting "Y's". I need to be able to count whether there's a
Y in EITHER one in the range (which pertains to a single day).

I tried to solve this with corresponding statements of -COUNTIF(C6, $D$6)
(etc), but for those in which there were NO Y's for the week, it returned a
negative number because it subtracted the fact that the N's are the same.

I'm stumped. Any help would be greatly appreciated, as I have 150 rows each
on 3 different sheets and manually adding up all these would take me a long
time (also, I plan to use this a great deal in the future, so it benefits me
for a great deal of time), so I'm hoping to get a response in the next couple
hours that will help me.

Thank you.