+ Reply to Thread
Results 1 to 2 of 2

how can i find the average of absolute values of a range of cells where the range varies?

  1. #1
    Forum Contributor
    Join Date
    03-10-2017
    Location
    USA
    MS-Off Ver
    office 2016
    Posts
    393

    how can i find the average of absolute values of a range of cells where the range varies?

    I have a column that varies from 1 to 24 rows. I need to find the average of the values, looking at their absolute value.

    I can use this
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    but if the data only goes to b25 or b24 or anything less than B26 then it will average in 0 to the formula. How do i check how low the column goes before calculating the abs average?

    I can use
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    to find the last row but i dont know how to plug in the result from this formula into the range of the formula above.

    Edit: Forgot to mention the column contains formulas that either return a number or "" so it has to ignore the ""
    Last edited by kevinu; 01-12-2019 at 03:32 PM.

  2. #2
    Forum Contributor
    Join Date
    03-10-2017
    Location
    USA
    MS-Off Ver
    office 2016
    Posts
    393

    Re: how can i find the average of absolute values of a range of cells where the range vari

    I figured out this formula but it still counts blank cells?
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    B29 has this formula to count # of rows with data in it but it counts blank cells

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The blank cells have this formula in them so technically its not a blank cell it has "" in it.

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Edit:

    Just figure out i was using countif when count would work so this formula works and makes the first formula work
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by kevinu; 01-12-2019 at 03:53 PM.

+ 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] Trying to Find Average of Values Based on Lookup Range
    By brafter70 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-13-2018, 02:17 PM
  2. Replies: 2
    Last Post: 02-09-2015, 04:40 AM
  3. [SOLVED] Need to find average of an array if corresponding values are within a set range
    By Pallav001 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-21-2013, 03:06 AM
  4. How to find the average of a range of cells?
    By anon in forum Excel General
    Replies: 6
    Last Post: 06-10-2012, 03:56 PM
  5. [SOLVED] How do I sum the absolute values of a range of cells?
    By fsinsd in forum Excel General
    Replies: 4
    Last Post: 03-15-2006, 05:45 AM
  6. Macro to find a range that varies.
    By Paul in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2005, 07:40 AM
  7. How do I get absolute values for a range of cells?
    By Terry in forum Excel General
    Replies: 4
    Last Post: 03-02-2005, 01:01 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