=SUMPRODUCT((A1:A1000=1)*(B1:B10001))

HTH
--
AP

"Thansal" a écrit dans le message de news:
...
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