+ Reply to Thread
Results 1 to 2 of 2

Countif Date given makes them within a certain age range

  1. #1
    Registered User
    Join Date
    09-27-2017
    Location
    US
    MS-Off Ver
    2013
    Posts
    28

    Countif Date given makes them within a certain age range

    Hi!

    I have a list of birthdays, and I'd like a function that CountIfs the birthdays fall within a certain age range, i.e. 0-8, 9-16, 17-26, etc.

    The function needs to be live, so it would have to also be able to countif birthdays tomorrow or a year from now based on a list of birthdays and be able to return a count of their age range breakdowns.

    Thank you for your time.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Countif Date given makes them within a certain age range

    =sumproduct(--(year($e$1:$e$52)<(year(today())-a8)))-sum(b9:$b$21)
    Attached Files Attached Files

+ 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. [SOLVED] Countif and date range
    By Sasquatch2014 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2015, 06:58 AM
  2. COUNTIF used with a DATE range
    By bobbles22 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-14-2014, 04:38 AM
  3. [SOLVED] COUNTIF with date range
    By erincox2010 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2014, 06:40 PM
  4. Countif Date Range
    By LisaG in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-30-2012, 06:19 AM
  5. COUNTIF date will expire in a date range
    By neilanderson in forum Excel General
    Replies: 6
    Last Post: 07-31-2012, 02:08 PM
  6. Combining a Date Range COUNTIF and a general COUNTIF
    By jacobtom in forum Excel General
    Replies: 1
    Last Post: 09-15-2011, 05:06 PM
  7. countif date range
    By joe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2005, 04:05 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