Thanks Domenic
I see the point.
Another one for the Michael archives

Regards
Michael Mitchelson


"Domenic" wrote:


Hi Michael,

If you always want Column C (labelled B) evaluated, then yes. But if
you change my formula as follows...

=PRODUCT(IF(A2:A7=G1,INDEX(B2:D7,0,MATCH(H1,B1:D1, 0))))

...where G1 contains the first crieterion, such as 'x', and H1 contains
the second criterion, such as 'B', then you can select the column you
want evaluated by entering the appropriate label in H1, such as A, B,
or C. If I'm not mistaken, I think that's what the OP was looking for.
:)

Michael Wrote:
Hi Domenic
Wouldn't this do the same thing.

=PRODUCT(IF(A4:A9="Z",C4:C9,""))

If I don't ask, I don't learn

Regards
Michael Mitchelson


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=394775