Hi there,
I have a small problem from a previous thread that I haven't worked out completly.
Previous thread:
The problem I have is that this formula is working out but not in all cases:
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
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:
Excel Formula:
=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