Using SUMIFS function with a wildcard on column full of numbers?

I'm trying to create a dynamic SUMIF formula with multiple criteria than can be changed. I've found that I can use "*" if I want to find the sum of anything in that field. But the "*" doesn't seem to work with numbers.
Please take a look at the example sheet I've attached. I can change the vehicle type and colour or put "*" to sum all, but I have to specify a number for the year if I want to get a sum. I can't use "*" for the year.

Any ideas?

You could try swapping out the asterisk (used with text) for a < big num, e.g.

=SUMIFS($F$4:$F$9,$C$4:$C$9,$K$3,$D$4:$D$9,SUBSTITUTE($K$4,"*","<9.99E+307"),$E$4:$E$9,$K$5)

Thanks! the <> worked.