![]() |
#1
|
|||
|
|||
![]()
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. |
Tags |
average and sum, count, weekday |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
tinfanide | Word VBA | 4 | 01-19-2013 11:31 PM |
'Linking' entered information to other "cells" from an original "cell" in MS Word | Wade | Word | 6 | 09-03-2012 05:22 PM |
![]() |
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
![]() |
Learner7 | Excel | 1 | 04-25-2011 04:39 AM |
Excel error: "Too many different cell formats" | enviroko | Excel | 0 | 01-09-2008 07:27 AM |