Hi all, I am trying to create an average formula that does not include any cells that have a value of zero. I know I can use AVERAGEIF() for a range of cells but I need it for a selection of individual cells.
I am using Excel 2010
Can anybody help?