Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-23-2015, 08:42 AM
rayramirezdvm rayramirezdvm is offline counting "x" in a cell and sum the numbers in weekday Windows 7 64bit counting "x" in a cell and sum the numbers in weekday Office 2013
Novice
counting "x" in a cell and sum the numbers in weekday
 
Join Date: Mar 2015
Location: East PEoria, IL
Posts: 2
rayramirezdvm is on a distinguished road
Unhappy counting "x" in a cell and sum the numbers in weekday

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.
Reply With Quote
 

Tags
average and sum, count, weekday



Similar Threads
Thread Thread Starter Forum Replies Last Post
counting &quot;x&quot; in a cell and sum the numbers in weekday DateValue: How to have a capitalised "weekday"? 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
counting &quot;x&quot; in a cell and sum the numbers in weekday How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
counting &quot;x&quot; in a cell and sum the numbers in weekday How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft