Average data columns ignoring hidden rows and zero values

  • Hi All,


    I recently joined this forum.


    I need to average the columns of data and ignore both hidden rows and zero values. I have tried writing if statements as well as the subtotal function. Both functions either ignore null values or hidden rows but not both.


    The system wont let me update a sample workbook but Im wondering whether there is a formula or combo formula for this.


    Thanks in advance, ps: no coding background :)


    udexcelstudent

  • Re: Average data columns ignoring hidden rows and zero values


    The forum returns an error message for uploads...


    And, I cannot add attachments on a PM.


    ....I am on excel 2007. have tried both if statements and subtotal 101. The IF statement does not ignore hidden values it only ignores zeros if thats the condition. The subtotal on the other hand ignores hidden values but not nulls.


    Any thoughts?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!