Results 1 to 1 of 1

If month in this cell is in current month, count this other cell?

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    1

    If month in this cell is in current month, count this other cell?

    Hi - I've found similar posts which have helped me get a start on this (thank you), but still aren't quite right. I've attached a generic sample copy of my spreadsheet and noted in red what I'm trying to do. Essentially, whenever someone leads a class, they will enter it onto this spreadsheet with the date, the number of sessions held on that date, etc...

    I need to provide Month-to-Date, Quarter-to-Date and Year-to-Date session count totals for each class. YTD is easy, but I'm getting stuck on the MTD and QTD formulas. I was able to apply a formula (in there currently for MTD on Class Type 1) that I thought would work until I realized it was counting the actual date cells, not the session cell for that date.

    Any thoughts? Hopefully it makes more sense once you see the spreadsheet, but if not, let me know? Thank you in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight cell if current month
    By her.rockstar in forum Excel General
    Replies: 4
    Last Post: 01-23-2013, 10:09 AM
  2. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  3. Cell contains current month
    By keith6292 in forum Excel General
    Replies: 1
    Last Post: 08-02-2011, 11:43 AM
  4. Populate the first day of the current month in a cell.
    By avidcat in forum Excel General
    Replies: 6
    Last Post: 12-30-2009, 06:40 PM
  5. Count specific dates in cell range for current month
    By rboggio1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2009, 10:21 PM

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