+ Reply to Thread
Results 1 to 7 of 7

How To Tally Number of Dates on Different Sheet to Populate on Original Sheet With Years

  1. 07-26-2017, 08:53 PM #1
    jdrenken7
    jdrenken7 is offline
    Registered User
    Join Date
    06-16-2017
    Location
    Columbia, MO
    MS-Off Ver
    Office 2007
    Posts
    16

    How To Tally Number of Dates on Different Sheet to Populate on Original Sheet With Years

    Thanks again!
    Attached Files Attached Files
    Last edited by jdrenken7; 07-29-2017 at 02:17 PM.
    Reply With QuoteRegister To Reply
  2. 07-26-2017, 09:25 PM #2
    gak67
    gak67 is offline
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: How To Tally Number of Dates on Different Sheet to Populate on Original Sheet With Yea

    Is this what you want?
    Attached Files Attached Files
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.
    Reply With QuoteRegister To Reply
  3. 07-26-2017, 09:57 PM #3
    jdrenken7
    jdrenken7 is offline
    Registered User
    Join Date
    06-16-2017
    Location
    Columbia, MO
    MS-Off Ver
    Office 2007
    Posts
    16

    Re: How To Tally Number of Dates on Different Sheet to Populate on Original Sheet With Yea

    Yes and No. I have quite a few risk listed as high and I'd like to separate the number of high and medium days also. Thank you for your help!
    Reply With QuoteRegister To Reply
  4. 07-26-2017, 10:02 PM #4
    gak67
    gak67 is offline
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: How To Tally Number of Dates on Different Sheet to Populate on Original Sheet With Yea

    Yeah, your sample data only showed MODT. You would need to duplicate those cells for the High and medium. Hopefully what I did points you in the right direction.
    Reply With QuoteRegister To Reply
  5. 07-26-2017, 10:10 PM #5
    jdrenken7
    jdrenken7 is offline
    Registered User
    Join Date
    06-16-2017
    Location
    Columbia, MO
    MS-Off Ver
    Office 2007
    Posts
    16

    Re: How To Tally Number of Dates on Different Sheet to Populate on Original Sheet With Yea

    I have updated the example file to include HIGH risk days. Sorry about that! Also, what did the 6,1 & 8,31 designate in the formula?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 07-26-2017, 10:20 PM #6
    gak67
    gak67 is offline
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: How To Tally Number of Dates on Different Sheet to Populate on Original Sheet With Yea

    June 1 to August 31. The title said Fall, but the dates in the sample date were only June so I made it Summer (northern hemisphere) instead.
    Reply With QuoteRegister To Reply
  7. 07-26-2017, 10:28 PM #7
    gak67
    gak67 is offline
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: How To Tally Number of Dates on Different Sheet to Populate on Original Sheet With Yea

    Check out the attached as an option.

    I have now made it Fall, which I assumed was 1 September to 30 November each year. Adjust those dates to match your own interpretations.
    Attached Files Attached Files
    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. Automatically copy rows to another sheet based on criteria, when original sheet is updated
    By NoviceProgrammer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2016, 02:14 AM
  2. PLEASE HELP! Need buttons to populate tally sheet
    By natyguido in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-23-2015, 09:05 AM
  3. [SOLVED] Filter the original sheet based on comparison and paste the results onto a new sheet
    By aviatecar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2014, 12:45 PM
  4. [SOLVED] Auto populate dates to figure in for leap years
    By SethS in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-08-2014, 06:49 AM
  5. [SOLVED] create new sheets and populate with data from original sheet
    By sommersc1 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-12-2013, 12:37 PM
  6. Multiple check boxes on Sheet 1 to populate a dropdown on Sheet 2 from a lists on Sheet 3
    By michaelfunk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2013, 12:54 AM
  7. create tally sheet for positions- insert names and tally #
    By tally sheets in forum Excel General
    Replies: 0
    Last Post: 04-11-2006, 04:45 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