Need help averageifs formula

Originally Posted by vlady

try this one


=IF((SUM(D6:D213)/COUNTIF(D6:D213,"<>0")>G6),SUM(L6:L213)/COUNTIF(L6:L213,"<>0"),"")


Please click on my scale at the right corner of the post if I helped you. Thanks.

Thanks, this worked well... never would of came up with that formula myself, your a life saver!