Results 1 to 6 of 6

Averageifs function not returning correct average

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2017
    Location
    Adelaide, Australia
    MS-Off Ver
    2010
    Posts
    10

    Averageifs function not returning correct average

    I have a scenario where i must determined the average number between an upper and lower bound (Ylower, yupper)

    The upper and lower bounds are calculated separately in the spread sheet and represent the depth of a concrete section. I have a separate array of values which contain all possible section depth.

    I need a function that will return the average value of the section depth between these bounds, noting that often one of the bounds is equal to a value 1.696 which is a constant depth for a significant length of the member.

    I am not sure why this is not working, but when one of the bounds is the 1.696 value (max height) then the average returned in equal to this number. The function appears to be working for my other scenarios.

    I have tried to explain this as clearly as possible but have found it difficult. I have attached the section of the spreadsheet which should be a bit clearer. There is also a pdf explaining the situation.

    Any help would be greatly appreciated, because I have hit a roadblock surfing through the internet for solutions.

    Cam
    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. Need help with averageifs function - keeps returning #DIV/0
    By JAWilliams in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-26-2015, 01:38 AM
  2. Percentile Function is not returning correct results
    By walters in forum Excel General
    Replies: 1
    Last Post: 03-10-2015, 10:52 AM
  3. [SOLVED] IF Comparison Function Not Returning Correct Data
    By emlit in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-24-2014, 01:44 PM
  4. Indirect function not returning correct value
    By iamskippy in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-16-2013, 04:28 PM
  5. [SOLVED] Is AVERAGEIFS the correct function to use?
    By IrrepressibleXL in forum Excel General
    Replies: 7
    Last Post: 03-27-2012, 07:28 PM
  6. Using AVERAGEIFS function to average a smaller subset of criteria data
    By RJS5062 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-22-2012, 04:19 PM
  7. MAX Function not returning correct value
    By Phil in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-28-2006, 05:20 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