(Your test data isn't very good - each day has attendance of 4. You need
different attendances on different days to get any results out of this.)

CountIf doesn't do things of this complexity, nor does any other standard
function. The idea of Excel is to stage your calculations. I.e. do
intermediate calculations, then roll them up into final calculations.

I've put your test data (with a couple of X's changed to A's) into the
following places:

Heading row: A14:D14
Blank row: A15:D15
Rest of it: A16:D20

In the blank row, put CountIf totals for each day. E.g. B15 is

=COUNTIF(B16:B20,"X")

which is copy/pasted to C15 and D15.

So now you have totals for each day. Next step is to select the one you
want. For this, you use HLookUp.

=HLOOKUP(A1,B14:D15,2,FALSE)