=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)

[TABLE="width: 500"]
<tbody>[TR]
[TD](A1)[/TD]
[TD]Jan (B1)[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[/TR]
[TR]
[TD]1:e[/TD]
[TD]256[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2:e[/TD]
[TD]IF value here is 0 then grab B2 value.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3:e[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!