Results 1 to 3 of 3

Thread: Average number of a specific number in group

  1. #1

    Average number of a specific number in group



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Basically I have a table that consists of numbers that grows daily- C2-AG2. as the month progresses they fill up right to left with numbers. In AI2, I would like to figure out how many of those cells = "0"

    Trickshot may also be, I would like to make sure the formula omits anything that is blank entirely.

    for instance if the cells read like:

    10|0|9|80|0|_|_|_|

    The formula should figure out that 2 out of 5 are "0", and therefor 40%

    Thanks in advance!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Try

    =COUNTIF(C2:AG2,0)

    and to figure out percentage..

    =COUNTIF(C2:AG2,0)/COUNT(C2:AG2)


  3. #3
    Quote Originally Posted by NBVC View Post
    Try

    =COUNTIF(C2:AG2,0)

    and to figure out percentage..

    =COUNTIF(C2:AG2,0)/COUNT(C2:AG2)
    Brilliant! worked perfectly- THANK YOU!

Posting Permissions

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