Min IFs not working

[dmj120]

I have a somewhat large data set that I've pivoted (a concat of three nomenclature columns) - data set is 80k rows, pivoted concat is only 28k rows. I'm trying to find the minimum, medium, and max prices.


I've tried both these, each gives a value error:
{=MIN(IFS('rptPricePoints'!$C:$C,$A4,'rptPricePoints'!$K:$K,">"&$B$1))}
{=MIN(IFS(rptPricePoints!$C:$C,$A7,rptPricePoints!$K:$K,">"&$B$1))}

'rptPricePoints'!$C:$C,$A4 = the concatenated nomenclature
'rptPricePoints'!$K:$K,">"&$B$1 = the minimum price of $14

The median and max formulas will be similar.
I get a value error with: {=MEDIAN(IF(rptPricePoints!$C:$C,A4,rptPricePoints!$K:$K))}

Where am I making a mistake?

Thanks
Josh

 

[dmj120]

Ok... I found a dumb mistake: =MIN(IF(rptPricePoints!$C:$C=$A4,IF(rptPricePoints!$K:$K,">"&$B$1,rptPricePoints!$K:$K))) which gets rid of the error, but results in a '0'

 

[dmj120]

UGH.... just found MINIFS().