occurence of two values.

[Rich]

I'm trying to work out how often a number appears in an
array with another number for example No.1 occurs 10
times in column A, No.2 appears 8 times in column B,
however they only appear 4 times together. There must be
a formula i can use for this saves me counting all the
different occurences.

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A1000=1)*(B1:B1000=2))
to count all occurences of '1' in col. A and '2' in the adjacent cell
in col. B

 

[Guest]

Frank,

you don't know how grateful i am!!

Danke vielmals!
Richard.