Average if to ignore 0 zero in data set

route217
route217 used Ask the Experts™
on
Hi Experts using excel 2013

i have the following formula which i need to amend to ignore and not count the cells with zeros in them to reduce the average
=IFERROR(AVERAGEIFS(INDIRECT("Data!$Bm$2:$Bm$2599"),INDIRECT("Data!$AQ$2:$AQ$2599"),$D$3,INDIRECT("Data!$bp$2:$bp$2599"),O$5,INDIRECT("Data!$bn$2:$bn$2599"),$G$5),"-")
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Microsoft Excel Expert
Top Expert 2014
Commented:
=IFERROR(AVERAGEIFS(INDIRECT("Data!$Bm$2:$Bm$2599"),INDIRECT("Data!$AQ$2:$AQ$2599"),$D$3,INDIRECT("Data!$bp$2:$bp$2599"),O$5,INDIRECT("Data!$bn$2:$bn$2599"),$G$5,INDIRECT("Data!$Bm$2:$Bm$2599"),"<>0"),"-")

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial