Array formula problem?

[quizzer]

I have a problem with the formula in cell D6 which is {=MIN(IF(Ex_Test_Code=BC6&BC3&BC4&BC2,sumif,"X"))} which works fine when I have a specific value in cell B3, but I would like to use a wildcard "*" in cell B3 to colect information on "RM & RT" But as soon as I put an "*" in the cell B3 it no longer works.

I have used similer formulas before and they work, this is the first time I have tried it in an array formula, is this the problem?

Thanks in advance for help that can be given.


1 A B C D
2 FALSE
3 RM
4 03/04
5 Ex Test Code Sumif Period Min Value
6 1RM03/04FALSE 22 1 7
7 1RM03/04FALSE 15 2
8 1RM03/04FALSE 21 3
9 1RM03/04FALSE 12
10 1RM03/04FALSE 7
11 1RT03/04FALSE 166
12 1RT03/04FALSE 21

 

[Andrew Poulsom]

I don't understand that formula

=MIN(IF(Ex_Test_Code=BC6&BC3&BC4&BC2,sumif,"X"))

I get a #NAME error (even if I define Ex_Test_Code).

Is something missing? If your formula contains a less than/greater than sign surround it with spaces or Disable HTML and repost.

 

[Aladin Akyurek]

Care to state, given the sample, what must be computed by means of a verbal description?