Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 03-23-2015, 12:00 PM
Snakehips Snakehips is offline counting &quot;x&quot; in a cell and sum the numbers in weekday Windows 8 counting &quot;x&quot; in a cell and sum the numbers in weekday Office 2013
Advanced Beginner
 
Join Date: Mar 2015
Posts: 36
Snakehips is on a distinguished road
Default

rayramirezdvm,

Firstly, not 100% idiot proof but you could count the X's by using e.g. for your C11 =LEN(C11)
It will actually count any characters but you will have to rely on user entry discipline to avoid spaces or maybe use..... =LEN(SUBSTITUTE(C11," ",""))

You could use SUMPRODUCT to compute some of the stats you want but given the variety of stats you mention above I think it would be worth restyling your raw data and then exploring the use of a pivot table.

Below is a link to one of a series of video tutorials (You Tube abounds with such things) that might be worth you watching.

https://www.youtube.com/watch?v=8ffdXfriLPQ
Hope that helps.
Reply With Quote
  #3  
Old 03-24-2015, 01:25 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline counting &quot;x&quot; in a cell and sum the numbers in weekday Windows 7 64bit counting &quot;x&quot; in a cell and sum the numbers in weekday Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Also get rid of the merged cells for the months ( well, I suppose they are merged cells). There is little one can do with pictures except admire the colours.
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 04-02-2015, 01:54 PM
rayramirezdvm rayramirezdvm is offline counting &quot;x&quot; in a cell and sum the numbers in weekday Windows 7 64bit counting &quot;x&quot; in a cell and sum the numbers in weekday Office 2013
Novice
counting &quot;x&quot; 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
Default Thanks - working great!

Thank you both!
I did rearrange the data, although not what the staff enter. They are _not_ tech savvy, so since they do this correctly, I wanted to keep it familiar.

I love that Excel can let me put the same data in a different cell, and that is what I did.

And the pivot table tutorials are amazing! I had a very crude knowledge of how they worked, but this has opened up several things that I want to do with other data that I have!

I have not completely got it figured out, but I am very close to getting the data in a format that will actually be helpful!
Thank you all so much!
Ray
Reply With Quote
  #5  
Old 04-02-2015, 02:58 PM
Snakehips Snakehips is offline counting &quot;x&quot; in a cell and sum the numbers in weekday Windows 8 counting &quot;x&quot; in a cell and sum the numbers in weekday Office 2013
Advanced Beginner
 
Join Date: Mar 2015
Posts: 36
Snakehips is on a distinguished road
Default

Ray,
Thanks for feedback and good luck with the project.
Reply With Quote
Reply

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 01:04 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