Results 1 to 10 of 10

Average/Sum Ignoring Blanks In-Range Help

Threaded View

  1. #1
    Registered User
    Join Date
    01-30-2023
    Location
    California
    MS-Off Ver
    Excel 365
    Posts
    4

    Average/Sum Ignoring Blanks In-Range Help

    Hello,

    I am trying to figure out a formula that can take the average of the separate sums of a few ranges of cells. But the catch is that I need the function to completely ignore any range that has all blank cells.

    Using the calendar template as a foot-traffic counter, I need the average of Mondays, Tuesdays, Wednesday, Thursday, & Fridays to be counted as they are input in each week. The catch is that I don't want the week to be counted in the average if ALL cells in that week are blank.

    I've tried a billion formulas over the past few days, and my latest effort is this:
    =AVERAGE((IF(COUNTA(B11:C19) > 0, SUM(B11:C19), "")),(IF(COUNTA(B22:C30) > 0, SUM(B22:C30), ""))).

    I hope this isn't too confusing, and I appreciate any advice.
    Attached Files Attached Files
    Last edited by Metapotamus; 01-30-2023 at 08:45 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 14
    Last Post: 04-25-2017, 03:11 AM
  2. [SOLVED] Average last n numbers ignoring blanks
    By Cryptic in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-06-2013, 07:05 AM
  3. Average tabs ignoring blanks
    By jbwizoz in forum Excel General
    Replies: 3
    Last Post: 11-16-2011, 05:00 PM
  4. Average ignoring Blanks cells
    By Justinmih in forum Excel General
    Replies: 10
    Last Post: 09-30-2011, 06:21 PM
  5. UDF to calculate average according to condition, ignoring blanks
    By dmitry in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-14-2011, 05:51 PM
  6. Replies: 1
    Last Post: 01-25-2011, 10:37 PM
  7. [SOLVED] Conditional Average Ignoring Blanks
    By Dirk Friedrichs via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2005, 11:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1