Results 1 to 2 of 2

How to average vallues across multiple columns based on a date range?

Threaded View

  1. #1
    Registered User
    Join Date
    03-27-2019
    Location
    Singapore
    MS-Off Ver
    2017
    Posts
    2

    How to average vallues across multiple columns based on a date range?

    Hi all,

    I want to average values across multiple columns based on a giver date in the same row.
    i have tried using
    =AVERAGEIFS(C2:G7,B:B,">31/1/19",B:B,"<1/3/2019")
    but it returns a #VALUE! error

    I have included a sample book containing my values and formulae.

    Will appreciate any help. Thank you!
    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. [SOLVED] Average Based on Multiple Criteria in Same and Different Columns
    By KoolKatelyn in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 02-20-2018, 02:15 PM
  2. Average based on Value from a different Cell but in multiple columns
    By fotodude in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-13-2017, 05:12 PM
  3. [SOLVED] Average ifs with multiple columns as the average range
    By moneypennie21 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-15-2017, 08:14 AM
  4. Average numbers from multiple columns based on multiple criteria
    By abambi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2015, 01:52 PM
  5. Replies: 10
    Last Post: 02-19-2013, 12:05 PM
  6. [SOLVED] Average Based on Criteria in Multiple Columns
    By sinspawn56 in forum Excel General
    Replies: 2
    Last Post: 07-31-2012, 01:27 PM
  7. Average multiple rows based on 2 columns
    By beaner in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-19-2011, 09:18 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