+ Reply to Thread
Results 1 to 2 of 2

Average of numbers between dates range in a table!

  1. #1
    Registered User
    Join Date
    12-17-2020
    Location
    London
    MS-Off Ver
    2010
    Posts
    55

    Exclamation Average of numbers between dates range in a table!

    Hello everyone,

    Trying to get the average of number's count in a table column, based on the dates range in the second column!

    Having a look at the sheet attached will better explain the issue I guess

    I have attached an example, I wish someone can help.

    Thanks.
    Attached Files Attached Files
    Last edited by BassemCh; 01-14-2022 at 04:39 PM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    6,884

    Re: Average of numbers between dates range in a table!

    try
    =AVERAGEIFS(A3:A24,B3:B24,">="&E4,B3:B24,"<="&E5)

    are you still using excel version 2010
    Attached Files Attached Files
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Replies: 3
    Last Post: 02-14-2015, 10:14 AM
  2. Average data from duplicate dates in a table
    By superdaw in forum Excel General
    Replies: 5
    Last Post: 09-17-2014, 09:42 AM
  3. Need an average for a range of numbers.
    By mwb12285 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-18-2014, 11:49 AM
  4. [SOLVED] Trying to make a table to average cells between two dates I specify in a workbook.
    By afazer in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-23-2014, 03:34 PM
  5. Average of a range of numbers....
    By sumospim in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2014, 09:24 AM
  6. Average days over range of dates?
    By JohnHolland in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-19-2011, 08:06 AM
  7. Average Days between a range of dates?
    By cp_ in forum Excel General
    Replies: 7
    Last Post: 02-08-2008, 08:56 PM

Tags for this Thread

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