Results 1 to 9 of 9

average last 8 values of a columns as new numbers entering

Threaded View

  1. 04-19-2021, 03:38 PM #1
    Excl3454
    Excl3454 is offline
    Registered User
    Join Date
    01-29-2021
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    96

    average last 8 values of a columns as new numbers entering

    hello,
    I guess I know how to find average or sum or nth rows, it always shows average of last 8 rows.
    but wondering if it is possible getting last 8 columns average of the numbers in a range ?
    like what si average for 1, or 2, or 10 in last 8 rows?

    Thank you screenshot.6114.jpg
    Attached Files Attached Files
    Last edited by Excl3454; 04-19-2021 at 05:26 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Average together two columns, including only numbers between two values
    By labratto in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-10-2021, 12:32 PM
  2. [SOLVED] Average if values in adjacent columns is >0 AND adjust the average range each time
    By ew17 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2020, 12:56 PM
  3. Finding average of values that are not numbers
    By kyopsis23 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2014, 02:35 PM
  4. [SOLVED] If values in a column are equal, then need to calc average of values in other columns
    By engineerlady in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2013, 02:33 PM
  5. How to compute an average of numbers in columns that have numbers, text, blanks and NA?
    By studiosa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-07-2013, 08:58 PM
  6. [SOLVED] VBA to restrict entering duplicate values in 2 different columns individually
    By Kiran_555 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2012, 08:07 PM
  7. VBA to restrict entering duplicate values in 2 different columns individually
    By Kiran_555 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2012, 01:39 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1