Return Value from Cell if false

[Elifly]

Hi there,

I have a small problem from a previous thread that I haven't worked out completly.

Previous thread:

Return Value from Cell if false

Hey there, I have the problem of not having my lookup function work correctly. If there is a False Value in somewhere in the J column, it should return the value of the Cell in the G column in the same row. But I only want the search range for dates that are the same, so I have a value for...

www.mrexcel.com

The problem I have is that this formula is working out but not in all cases:

=MAXIFS(...)+SUMIFS(G:G,A:A,date,J:J,FALSE)

I somehow have to doublecheck in the SUMIF if the value from MAXIFS is not the SUMIFS value.
I don't really know how to expand the formula for this case.

Thanks in advance

 

[AlanY]

could you post the data that the formula not working here

 

[Elifly]

I have solved the problem already but thanks anyway ^^