=min(if(b6:b34="2006",E6:e34))

Enter with Ctrl+shift+Enter

Is 2006 text or number: remove quotes if latter.

"Alex" wrote:

Hi, using an accounting format on Row E, I am trying to extract thje lowest
value from E6:E34 where B6:B34 = 2006.

I am using: =MIN($B$6:$B$34,"2006",E6:E34), but Excel is returning a value
for a row that does now have the cell in Column B set to 2006.
Can some kind person tell me what I'm doing wrong please - thanks

A