MAXIFS problem - Trying to find max when another cell is N

[ollyhughes1982]

Hi. In my file (link below) and worksheet 'All Completed Runs - Misc. Met.', please could someone solve what is going wrong with my formula in cell B2? (highlighted orange). I am attempting to find the max value in the AR column of the ‘All Completed Runs’ worksheet, whenever there is an entry and column C.

My current attempt at a formula in cell B20 is: =MAXIFS('All Completed Runs'!AR3:AR2002,'All Completed Runs'!C3:C2002,C225<>"")

https://1drv.ms/x/s!AtIvkRgReIvwgTdNIGandjTeGGdr?e=3ZCtRH

Thanks!

 

[jasonb75]

Without opening your file I would say that it should be

=MAXIFS('All Completed Runs'!AR3:AR2002,'All Completed Runs'!C3:C2002,C225,"<>")

 

[Fluff]

Or maybe
=MAXIFS('All Completed Runs'!AR3:AR2002,'All Completed Runs'!C3:C2002,"<>")

 

[ollyhughes1982]

Thanks all. This is now solved.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[jasonb75]

Good catch, Fluff. I hadn't noticed the stray 'C255' in the formula, I could see that yours was shorter but had to go over mine 3 times before I noticed the error

 

[Fluff]

It took me a while to spot the difference, between you formula & the OP's