+ Reply to Thread
Results 1 to 2 of 2

Google Sheets: Average but without using range

  1. #1
    Registered User
    Join Date
    04-13-2020
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    29

    Google Sheets: Average but without using range

    Hello! Just want to ask if there is an easy way for me to find the average but not using range since the values are placed in different cells?

    Here the cells and the formula that I'm using to get the average (J28+O28+T28+Y28+AD28+AI28+AN28+AS28+AX28)/8

    It is working, yes. But the problem is that there is a cell that the value may be empty. For example, all of it has a value except for AS28 & AX28, so the denominator should be 6 and not 8.

    Is there a way for me to easily do this? Thanks!

  2. #2
    Valued Forum Contributor hrlngrv's Avatar
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,145

    Re: Google Sheets: Average but without using range

    Try each of the following

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


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


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

+ 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. Google Sheets: Average ignoring cells without data
    By Jack_Jigson in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 06-15-2020, 04:19 AM
  2. Google Sheets: Ignore Errors and Calculate Average
    By Manikandan Arumugam in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 13
    Last Post: 06-07-2020, 12:39 AM
  3. Average n top values with data chosen by mutliple criteria - Google sheets
    By david.gnaniah in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-28-2020, 07:53 PM
  4. GOOGLE SHEETS: countif with dynamic range
    By Headburst in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 11
    Last Post: 12-30-2019, 09:59 AM
  5. Import Range Selecting Range [Google Sheets]
    By Fredbugatti in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 10-31-2018, 03:06 AM
  6. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  7. Average weekday revenue (Google Sheets)
    By djarcadian in forum Excel General
    Replies: 5
    Last Post: 08-07-2014, 05:00 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