COUNTIF() With multiple ranges and variables
 

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

COUNTIF() With multiple ranges and variables
 

=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

COUNTIF() With multiple ranges and variables
 

=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

COUNTIF() With multiple ranges and variables
 

Thank you all.

It took me a long time, but that was b/c I had an error in my data that
I had not caught.
Sloth wrote:
=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