=SUMPRODUCT(--(A1:A6=1),--(B1:B61))

"Thansal" wrote:

The function I am looking for is something that will simply look at 2
ranges (euqaly large) and only count them if they meet 2 criteria on
the same row

EX:

A B
1 1
1 2
1 3
2 1
2 2
2 3

So what I am sorta looking for is something that would count the
instances where A = 1 and B 1.

I can't figgure out a propper function for this.

Any help would be appreciated.

AlexV