Hello! I have a formula as follows

=AVERAGEIFS(Sheet2!AE:AE,  Sheet2!A:A,A1, Sheet2!AE:AE,">0")
But I only want to average those numbers when there are 5 or more such instances of positive numbers.

Tried this but it doesn't work:

=AVERAGEIFS(Sheet2!AE:AE,  Sheet2!A:A,A1,  Sheet2!AE:AE,">0",  Sheet2!AE:AE,(COUNTIF(Sheet2!AE:AE,">0"))>=5)
I'm guessing this has a simple solution, but I've been thinking about it for awhile and can't figure it out.