+ Reply to Thread
Results 1 to 5 of 5

Avoiding a #DIV/0! result when using AVERAGE on empty cells

Hybrid View

  1. 09-29-2008, 11:02 AM #1
    AB_Summit
    AB_Summit is offline
    Registered User
    Join Date
    09-27-2008
    Location
    Canada
    Posts
    9
    That solved it, Thanks!
    Reply With QuoteRegister To Reply
  2. 09-29-2008, 12:14 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Or =IF(COUNT(A1:A3), AVERAGE(A1:A3), "")
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Moving average excluding blank cells
    By bog3494 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-28-2011, 07:18 PM
  2. "Translating" numbers into words
    By Portuga in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2008, 11:44 AM
  3. Spell number
    By nowfal in forum Excel General
    Replies: 4
    Last Post: 08-20-2007, 04:21 PM
  4. searching merged cells
    By chris_mayer in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-30-2006, 11:14 AM
  5. searching for empty cells in a range
    By chris_mayer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2006, 07:23 AM

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