occurence of two values.

  • Thread starter Thread starter Rich
  • Start date Start date
R

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.
 
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
 
Back
Top