On 2002-04-24 10:06, dawnfoss wrote:
a b

1 ab 20
2 xy 10
3 kr 15

I want to add the values of b ONly if the values in a = xy or kr. The result should be 35.


Note: This is an array formula which is entered using the Control+Shift+Enter key combination. For more on array formulas see the Excel Help Index topic for "About array formulas and how to enter them".