MAX IF Formula not working

[Nikijune]

Hello,

I'm so frustrated as I know this is going to be something simple....

I have a MAX IF Function, as below, however, it is returning the MAX number of the whole data, and not just of the data specified in my IF part of the statement. The frustrating part is, that when I go into the function box, it displays the correct answer, its just not translating into the spread sheet.

=MAX(IF('Raw Data'!C:C = "HP CMS Pilot",'Raw Data'!H:H))

Thanks in advance

 

[63falcondude]

Are you confirming the formula with Ctrl Shift Enter?

 

[Nikijune]

I knew it would be something so easy!

Thank you so much - I was ready to quit my job!!!

 

[63falcondude]

Glad to help!

 

[RyanAA]

I hate to say it, but I am having a similar issue and I believe I have done all of the tricks, ctrl + shift+ enter and tried changing the formats (text, general and such). I get a zero when there is clearly data there. I am trying to get the min, max and median for Mondays, Tuesdays, and so on... I am not getting errors, just zeros.