=MIN( with conditions)

[still learning]

Hi
I'm stuck
What do I add to this formula to exclude any number from 25,000 and below?

=MINIFS(B2:B200,

Or am I using the wrong approach


Mike

 

[etaf]

=MINIFS(B2:B200,B2:B200,">"&25000)

Book2
	A	B	C
1			25001
2		25001
3		1
4		2
5		10000
6		5
7		25000
Sheet1

Cell Formulas
Range	Formula
C1	C1	=MINIFS(B1:B13,B1:B13,">"&25000)

 

[still learning]

Hi etaf
Thank you

mike

 

[etaf]

you are welcome