Max with criteria

[toony]

Hi. I have the below issue.

I have the below formula that works;
=MAX(IF(AD:AD="office supplies",AP:AP))

Then I have this othee formula which gives me 0 for the Furniture criteria......but the highest is not 0....
It's just the same formula but different criteria. I checked the spellling and all but can't just see why it woul give me 0 value. Any ideas?
=MAX(IF(AD:AD="Furniture",AP:AP))

 

[toony]

How do I verify that if gives 7? Not sure how or what you mean sorry. I did verify one of the Furniture criteria cells and it gave TRUE.

 

[RoryA]

You said that the 7 was wrong and should be 3. I'm just asking how you actually verified that? I can't see how that formula would come up with 7 if there isn't a 7 for furniture.

 

[toony]

Hi Rory. Actually you are correct really apologies. The max value for the Furniture criteria is actually 7 so that's correct.

The array formula =MAX(IF([Product Category]="Furniture",[Days to Ship using DATEDIF])) works brilliant

Thanks again to everybody you all are brilliant!