Share via

How do i get my formula to not count zeros in the in the avearged amount

Anonymous
2023-02-07T17:05:17+00:00

i am tracking the time it takes for some people to do there charting. i have the graph so that it will not read the zero when it is counting weekly but when i have it total the month it is counting the zeros and lowering the percentage exp.

=average(d6,f6,h6,j6) d6 was 0%, but the rest were 100% it is bringing the percentage down

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-07T17:51:18+00:00

    Hello, I am Leonielhou, an Independent Advisor and a user like you, I am happy to help clarify any questions you may have.

    Try to use the AVERAGEIF function in Excel. The AVERAGEIF function calculates the average of values that meet a specified criteria.

    Example: =AVERAGEIF(D6:J6, ">0", D6:J6)

    This formula will calculate the average of the values in D6:J6 that are greater than 0.

    10+ people found this answer helpful.
    0 comments
  2. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2023-02-07T23:38:41+00:00

    Hi,

    Try this formula

    =AVERAGE(FILTER(CHOOSECOLS(D6:J6,1,3,5,7),CHOOSECOLS(D6:J6,1,3,5,7)>0))

    5 people found this answer helpful.
    0 comments
  3. Anonymous
    2023-02-07T18:09:32+00:00

    Thank you! so i just put the ">0", after all my numbers and then put the numbers again?

    =averageif(d6,f6,h6,i6,"0",d6,f6,h6i6)

    is this right?

    0 comments