count

D

d sweeney

I am trying to count two colums if they both meet/match a curtain number.

Example if A1 = 2 and B1 = 12 then add one to the count.

The array that I am trying to count is two colums, A2:A800 and B2:B8000
 
M

Myrna Larson

To count the matches in COLUMNS A and B:

=SUMPRODUCT((A2:A800=2)*(B2:B800=12))


On Mon, 21 Feb 2005 13:07:06 -0800, d sweeney <d
 
Top