Results 1 to 2 of 2

Thread: Average With Exclude Text,Blank Cell, Zero Number

  1. #1
    Board Regular muhammad susanto's Avatar
    Join Date
    Jan 2013
    Location
    KPKNL Pekanbaru, Riau
    Posts
    1,499
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Average With Exclude Text,Blank Cell, Zero Number

    hi all..

    how to make average formula exclude 3 criteria text, blank cell, zero (0)
    =IF(COUNT(H8:T8);AVERAGE(H8:T8);"")

    but still not fully working

    thanks in advance..

    .sst
    Sembunyikan & rahasiakan amal kebaikan kita sebagaimana kita mahir dalam menyembunyikan aib-aib kita

    Play in Ms Excel 2007 & 2013 on Win 7 32 Bit

  2. #2
    Board Regular steve the fish's Avatar
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,671
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Average With Exclude Text,Blank Cell, Zero Number

    Try

    =AVERAGEIFS(H8:T8,H8:T8,">0")
    Looking for opportunities

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •