I know this must be easy, but I am missing something as I am trying to work through this.



My staff are tracking how many 'same day appointments' we get on a specific day. They put together this spreadsheet (which was easy for them) and the "X" represent an appointment made on the same day.
<sameday_apt.png
What I want to be able to do is to 'count' the number of "X" in a cell, and then categorize by day of the week, so how many same day appointments are on Monday AM, and Monday pm in April, or May, or for a quarter?, and how many on average for a quarter.

I believe I can do the last part - summing and averaging. But getting the total in a day of week format....

I put together this chart with the 'weekday' function that tells me which day of the week the days are,



I just need some help putting it all together.

I am thinking something like "=COUNTIF(J6,"X")" (without quotes) but it does not count the "X" in the cells.
Then I still have to figure out the way to separate 'weekday2, weekday 3, etc, but i think I can figure that out if I can count the number of 'X' in the cell

Thanks in advance for any help.