+ Reply to Thread
Results 1 to 3 of 3

Trying to Create a Spreadsheet that shows # of individuals attending on a specific day

  1. #1
    Registered User
    Join Date
    09-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    9

    Trying to Create a Spreadsheet that shows # of individuals attending on a specific day

    I'm trying to create a spreadsheet in which we're keeping track of individuals attending on specific days of the week. Example: How many individuals attended on Mondays in the month of January and then for the rest of the months of the year. We're looking to see a trend of which days have more attendance. I thought I had it be having the months of the year as my first column and then columns with #'s 1-31 across the top split with the day of the week drop-down option. However, I don't think this will allow me to grab all of the Mondays in the month. Anybody have any suggestions since I'm hitting a mental block and I'm not familiar with all the functionality of Excel.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,874

    Re: Trying to Create a Spreadsheet that shows # of individuals attending on a specific day

    The following attachment creates a calendar in rows 4:15. This table can be hidden.

    The attendance is in rows 19:30. I dummied up some numbers and stuck them in there.

    The solution (Columns AG:AM) uses SUMPRODUCT. To understand how SUMPRODUCT works, see this article: http://www.utteraccess.com/wiki/inde...Array_Formulas.

    SUMPRODUCT is not an array formula, but it acts like one.
    Attached Files Attached Files
    Last edited by dflak; 12-23-2015 at 05:46 PM.

  3. #3
    Registered User
    Join Date
    09-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Trying to Create a Spreadsheet that shows # of individuals attending on a specific day

    Thank you so much for your help! Happy Holidays!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create individuals' Timetables from Schedule of Global Data
    By hokkaido19 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 03-10-2016, 04:20 AM
  2. Replies: 2
    Last Post: 05-05-2015, 05:13 AM
  3. Spreadsheet for tv shows watched? [help]
    By himynameisiain in forum Excel General
    Replies: 0
    Last Post: 01-13-2013, 04:19 PM
  4. Replies: 9
    Last Post: 05-17-2012, 09:36 AM
  5. Replies: 3
    Last Post: 04-18-2012, 07:48 AM
  6. create combined list, summing scores for individuals
    By tamskinner in forum Excel General
    Replies: 2
    Last Post: 02-16-2012, 10:57 AM
  7. Excel Spreadsheet Shows Nothing!
    By Dolphinv4 in forum Excel General
    Replies: 2
    Last Post: 10-03-2005, 07:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1