+ Reply to Thread
Results 1 to 3 of 3

Should be Simple

  1. #1
    Registered User
    Join Date
    08-08-2005
    Posts
    2

    Should be Simple

    This doesn't seem to be all that difficult but my excel skills are weak to say the least. I have searched but my wording has produced nothing. I need to get an average of cells while ignoring the cells with zeros. What would the formula be for this? Thanks in advance.

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996
    Try these:

    =SUM(A1:A10)/SUMPRODUCT(--ISNUMBER(A1:A10)*(A1:A10<>0))

    =SUM(A1:A10)/(COUNT(A1:A10)-COUNTIF(A1:A10,0))

    Does that help?

    Ron

  3. #3
    Registered User
    Join Date
    08-08-2005
    Posts
    2
    thanks the 2nd one did it

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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