=MAXIFS can't be 0

[Weeble]

I am using a MAXIFS formula to determin a MAX value based on date and day from antother sheet
Problem is if there is no value on a date it will return 0. I need a formula that states IF the MAX returns 0, then it should just grab the number on the date above it.
ex.

=MAXIFS(Lager!$D:$D;Lager!$A:$A;B5;Lager!$B:$B;$C$2)

(A1)	Jan (B1)	Feb	Mar	Apr
1:e	256
2:e	IF value here is 0 then grab B2 value.
3:e

<tbody>
</tbody>

Anyone know how this could be done?

 

[wideboydixon]

Well, the longhand would be:

=IF(MAXIFS(Lager!$D:$D;Lager!$A:$A;B5;Lager!$B:$B;$C$2)=0;B2;MAXIFS(Lager!$D:$D;Lager!$A:$A;B5;Lager!$B:$B;$C$2))

But you might get away with:

=IFERROR(1/1/MAXIFS(Lager!$D:$D;Lager!$A:$A;B5;Lager!$B:$B;$C$2);B2)

WBD

 

[Weeble]

Well, the longhand would be:

=IF(MAXIFS(Lager!$D:$D;Lager!$A:$A;B5;Lager!$B:$B;$C$2)=0;B2;MAXIFS(Lager!$D:$D;Lager!$A:$A;B5;Lager!$B:$B;$C$2))

This worked

=IFERROR(1/1/MAXIFS(Lager!$D:$D;Lager!$A:$A;B5;Lager!$B:$B;$C$2);B2)

Tried this one out, but ended up with 0,00049 so I guess if I don't have an even number it won't get get 0 and give me a decmal number instead.


But thank you for the help!