Maxifs and Minifs formula

[Sarah23]

I am hoping someone may be able to help. I keep trying but it says it is not correct, and I am sure it is something really simple that I am getting wrong.

So I have the below formulas, which is looking for the Min and Max value using specific criteria. As it is dates, when there is anything for that criteria it comes up with 00/01/1900. Now I know I can build the below into a If formula to bring zero back blank but I cant get it to work

=MINIFS('Gatehouse Report'!$A:$A,'Gatehouse Report'!$E:$E,$C3,'Gatehouse Report'!$C:$C,$A3)
=MAXIFS('Gatehouse Report'!$A:$A,'Gatehouse Report'!$E:$E,$C3,'Gatehouse Report'!$C:$C,$A3)

Any help much appreciated.

 

[ValuationMan]

It's hard to know exactly how to fix it without a better description of your data. My version of Excel doesn't have the Maxifs and Minifs formulas.

You can do something like this

=MAX(IF((Condition1)*(Condition2)*(ConditionN), ResultRange)) you then do CTRL + SHFT + ENTER

I have had issues with dates in the past. It may be worth checking if your dates are stored as text using ISTEXT. That happens frequently with some programs, such as QuickBooks.