Excel question


  #1  
Old 11-20-19, 08:58 AM
N
Member
Thread Starter
Join Date: Nov 2007
Location: NW. Ohio
Posts: 96
Received 0 Votes on 0 Posts
Excel question

I use excel to make our work schedule. There is a column of names of workers with the days if the week in a row across. I put a "X" in the boxes of the days they work. I would like to be able to auto count the "X" s in the column for each day so I know how many employees I have for each day. I need to make the "X" equal a value of 1.
Is this possible?
 
  #2  
Old 11-20-19, 09:07 AM
2
Member
Join Date: Jan 2014
Location: USA near Boston, MA
Posts: 1,918
Received 255 Votes on 220 Posts
Use the COUNTA() function at the bottom of each column.

e.g. In column A, Row 12 :

=COUNTA(A1:A11) returns the number of "X"s in column A, rows 1 through 11)

If there are other letters in the cells it will count them also. If you have mixed letters and only want to count Xs use the DCOUNTA function.
 
nightowl66 voted this post useful.
  #3  
Old 11-20-19, 09:33 AM
N
Member
Thread Starter
Join Date: Nov 2007
Location: NW. Ohio
Posts: 96
Received 0 Votes on 0 Posts
Can you give me an example on how to use the DCOUNTA function?
 
  #4  
Old 11-20-19, 11:06 AM
J
Member
Join Date: Sep 2002
Location: welland ontario
Posts: 8,286
Received 442 Votes on 367 Posts
  #5  
Old 11-20-19, 02:37 PM
A
Member
Join Date: Jan 2013
Location: U.S.A.
Posts: 2,120
Received 72 Votes on 65 Posts
You can click on the cell where you want the result, type "=count()", place your cursor between the parenthesis, press and hold the control key, use your cursor to select the rows you want to include, then hit enter. Or, in the first step, you can type just "=count" and will get a drop down that shows you the available options for this function.
 
 

Thread Tools
Search this Thread
 
Ask a Question
Question Title:
Description:
Your question will be posted in: