NDnathan
New member
- Joined
- Oct 20, 2021
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2017
Hello! I have a formula as follows
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:
I'm guessing this has a simple solution, but I've been thinking about it for awhile and can't figure it out.
Code:
=AVERAGEIFS(Sheet2!AE:AE, Sheet2!A:A,A1, Sheet2!AE:AE,">0")
Tried this but it doesn't work:
Code:
=AVERAGEIFS(Sheet2!AE:AE, Sheet2!A:A,A1, Sheet2!AE:AE,">0", Sheet2!AE:AE,(COUNTIF(Sheet2!AE:AE,">0"))>=5)