Array formulas not working in Excel 2003.

  • Thread starter Thread starter kamelone
  • Start date Start date
K

kamelone

I am trying to use array formulas (to find the value in col C in a row
meeting two criterias in col A and B), but can't seem to make it work.

Problem is I can't even get Excel examples that I copy from the help file to
work with Array formulas. I have tried ctrl+shift+enter and using {}, but no
luck.

Is there any way the array formulas could have been disabled?
 
=INDEX(rngC,MATCH(1,(rngA="criteria 1")*(rngB="criteria 2"),0))

ctrl+shift+enter, not just enter
 
Hi,

It would help if you showed us the formula you are using. If there can be
only one value that meets the two conditions then

=SUMPRODUCT(--(A1:A10="condition1"),--(B1:B10="condition2"),C1:C10)

no array entry needed.
 
Back
Top