ERR:510 when using simple MINIFS formula

[Moshpirit]

I created this post earlier today in Spanish (relevant because of the attachment) where I have this formula =DIASEM(MIN.SI.CONJUNTO(F:F;E:E;<>1))-1, in English I think it is =WEEKDAY(MINIFS(F:F; E:E; <>1)) -1 returning (Err:510).

The idea is: I want the weekday (minus 1) of the minimum date (column E) which cell in column F is different than 100% (basically 1)

So if F7 is the minimum date but E7 is 100% then it should be ignored.

What am I missing?

[erAck]

@Moshpirit

=WEEKDAY(MINIFS(F:F; E:E; <>1)

Written like that the expression <>1 lacks a left operand, hence Err:510 Variable missing (message on status bar when that cell is active).
However, that’s not what you want, you likely want to match values in the range E:E that are not 1, so the Criterion should be "<>1" as string:

=WEEKDAY(MINIFS(F:F; E:E; "<>1")) -1