Array Formula possible?

[seboseszuk]

This formula is entered in column D row2 and pulled down to the last row.
if(Isnumber(match(A2,,,)*Isnumber(match(B2,,,))=1,1,"")
giving values of 1 where both conditions are met, spaces elsewhere.

Is it possible to sum these 1's with an array formula?


How does one copy formula, files into this message area and from here into an Excel file?


Gabor
(thanx to all readers)

 

[barry houdini]

Try

=SUMPRODUCT(Isnumber(match(A2:A100,,,))*Isnumber(match(B2:B100,,,)))

extend ranges as required

 

[seboseszuk]

Thanks Barry,works perfectly.

Gabor