+ Reply to Thread
Results 1 to 6 of 6

If then formula that includes counting

  1. 12-20-2013, 02:08 PM #1
    nclaus1018
    nclaus1018 is offline
    Registered User
    Join Date
    12-18-2013
    Location
    20823299498
    MS-Off Ver
    Excel 2010
    Posts
    4

    If then formula that includes counting

    I am trying to creat a summary sheet to an attendance log that goes back several years. Idealy, I want to be able to set a date range in the formula that will show me a count of how many absenses, lates, or leave earlies. The table I am taking the data from has columns from left to right (Date, Absense, # of Absenses, Late, Duration of, Left Early, Duration of, and MP) For example in column A I want to see the date Range of 10/1/2013 to 4/1/2014 and I want a count/sum of each of the categories.

    I hope I explained in enough detail. Please help!
    Reply With QuoteRegister To Reply
  2. 12-20-2013, 02:15 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: If then formula that includes counting

    Hi and welcome to the forum

    It would be easier to be more precise if you could show us samples of what you are working with and what you want, but take a look at using the COUNTIFS() function, something like...
    =countifs(date-range,">=10/1/2013",date-range,"<=4/1/2013",type-range,"late")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 12-20-2013, 02:32 PM #3
    nclaus1018
    nclaus1018 is offline
    Registered User
    Join Date
    12-18-2013
    Location
    20823299498
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: If then formula that includes counting

    Capture.JPG

    This is a screen shot of what I want captured on a summary page. I have tabs in the workbook with all of my employees names and I want to see at a glance with a specified date range the # of absenses... etc.
    Reply With QuoteRegister To Reply
  4. 12-20-2013, 02:40 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: If then formula that includes counting

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)
    Reply With QuoteRegister To Reply
  5. 12-20-2013, 02:46 PM #5
    nclaus1018
    nclaus1018 is offline
    Registered User
    Join Date
    12-18-2013
    Location
    20823299498
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: If then formula that includes counting

    Here is a sample of what I'm working with. The page that has data I will have 80+ of them in my file but I want a summary page where I can edit the formula for the date range I'm looking for and see sums of the data.


    SAMPLE.xls
    Reply With QuoteRegister To Reply
  6. 12-20-2013, 03:21 PM #6
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: If then formula that includes counting

    If you want to just count the occurrences...
    =COUNTIFS($A$3:$A$30,">=4/12/2013",$A$3:$A$30,"<=11/4/2013")

    If you want to add the amounts...
    =SUMIFS($G$3:$G$30,$A$3:$A$30,">=4/12/2013",$A$3:$A$30,"<=11/4/2013")
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help with formula that includes dates
    By kirkts in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-27-2012, 02:51 PM
  2. [SOLVED] Nested If Formula which includes IF(And
    By lottidotti in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2012, 01:27 PM
  3. [SOLVED] Counting Cells that includes exact match and also if a cell includes specific text
    By smclachlan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2012, 07:42 PM
  4. Counting occurences which includes text
    By Tomac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2006, 01:50 PM
  5. Counting occurences which includes text
    By Tomac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2006, 12:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1