Firstly SUMPRODUCT is not an array formula. Just commit it with a simple
ENTER

How about =SUMPRODUCT(--((A1:B10)={"Ford","Chrysler"})) ?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"avi" wrote in message
...
Hello,

I was referred by Bob Philips to to the SUMPRODUCT array formula
method which works incredibly fast. But it look as if the formula does
not work with non-contiguous ranges, for exemple:-

=SUMPRODUCT(--((A1:A10,B1:B10)={"Ford","Chrysler"}))

Any help will be appreciated

Avi