You may also want to consider SumProduct or Sumif which do not have to be array entered.

With criteria in B1 and C1

Each of the following gives the same result;

=SUMPRODUCT((B5:B26="Northwind")*1+(B5:B26="Terra Firm")*1,F5:F26)

=SUMPRODUCT((B5:B26=B1)*1+(B5:B26=C1)*1,F5:F26)

=SUMPRODUCT((B5:B26={"Northwind","Terra Firm"})*(F5:F26))

=SUMPRODUCT((B5:B26=B1:C1)*(F5:F26))

=SUMIF(B5:B25,B1,F5:F25)+SUMIF(B5:B25,C1,F5:F25)

or the array formula

{=SUM(IF((B5:B26="Northwind")+(B5:B26="Terra Firm"),F5:F26))}

Do not type the {} Excel presents these when formula is Array Entered with Ctrl+Shift+Enter (CSE).

This message was edited by Dave patton on 2002-10-13 12:35