Counting columns based on conditions

[mike4777]

Hi there. Just want to say, I am familiar with countif(s) formula. I just can't seem to see the solution clearly enough for my scenario.

I have a tab "Sign in Sheet". It is for a medical class. People sign in on column B11 and down. In columns J and K we put a "y" to indicate they showed up for day 1 or day 2. Some individuals may show up both days, some the first day only and some the second day only. I want to count everyone that showed up once. I can count row one and row two with

sum(countif(J11:J50, "y"), countif(K11:k50, "y")

But this will count those who showed up both days twice. I'd also like to count how many only showed up on day 1 and how many only showed up on day 2.

So perhaps a formula that will do the following:

Count everyone that showed up on: Both Days, just day 1, just day 2 (three formulas)

I could then gather add those all together to get my total.

Any help would be greatly appreciated. Thanks.

 

[shaowu459]

=SUMPRODUCT(N(J11:J50&K11:K50="yy"))

this formula tells you how many students showed up on both day1 and day 2.

 

[shaowu459]

=COUNTIFS(J11:J50,"y",K11:K50,"y")

do the same thing

 

[mike4777]

=COUNTIFS(J11:J50,"y",K11:K50,"y")

do the same thing

Thanks. This works great.