Minifs with OR criteria

[Setofskills]

I'm trying to create a list of unique project numbers that have outstanding invoices. I have a data query which pulls data into my Data! tab, the query returns the age of the invoices in date range buckets (eg <60 days, 61-90 days, >90 days).

That is, column L has the amount of money owed that is less than 60 days outstanding, column M has the money owed that is 61-90 days old, and column N has money owed that's more than 90 days old.

I'm calling the data values on the Data! tab and trying to list them in numerical order with the minifs function. To do that, I'm trying to find the first value and I can't figure this part out.

I'm trying to get a function similar to these (except one that works!):
=Minifs(Data!$E:$E,OR(Data!$L:$L,Data!$M:$M,Data!$N:$N,"<>"&0)

This also doesn't work:
=Minifs(Data!$E:$E,Data!$L:$N,"<>"&0)

This also doesn't work:
=Minifs(Data!$E:$E,{Data!$L:$L,Data!$M:$M,Data!$N:$N},"<>"&0)

My issue is that I need an OR criteria on the range, I need the smallest project number that has any old debt outstanding. How do I do this!?

Any help will be greatly appreciated!

 

[istiasztalos]

Hi

Unless I'm mistaken you intend 'OR(Data!$L:$L,Data!$M:$M,Data!$N:$N' to basically take that row's value from whichever column is filled, L, M or N ...

Then you could try to use an array formula to merge the columns by summing the arrays, like Data!$L:$L+Data!$M:$M+Data!$N:$N (and then enter the formula with CTRL+SHIFT+ENTER)

However I'm now sure how you intend to sort them, I believe minifs would only give you the smallest amount/invoice, not sort all items