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

try
=min(if(B6:B34="2006",E6:E34)) entered as an array control-shift-enter

or
=min(if(year(B6:B34)=2006,E6:E34)) entered as an array control-shift-enter

depending on the format of column B (Text or date)

Min by itself does not have a qualifier capability so your equaiton was
looking for the min in B6:B34 and E6:E34

"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

=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