Hi Karl,

This worked for me, however it is an array formula so you must use Ctrl
+ Shift + Enter to enter it...

=MAX(IF(A1:A44=7,B1:B44))

Adjust addresses to suit

Ken Johnson