CountIf for multiple colums

[Jacques]

I would like to create a formula that counts the occurance
in a column, but only if the first column has a certain
value...

A B
Q104 1
Q104 1
Q204 2

So for the above, any row that has a "1" AND "Q104" would
count as one occurance, the "1"'s would equal 2 and
the "2"'s would equal 1.

 

[Peo Sjoblom]

=SUMPRODUCT(--(A2:A10="Q104"),--(B2:B10=1))

 

[Mike]

Peo:

I understand the sumproduct formula, but do not
understand how you use it here. Could you tell me what
the two dashes do for each array?

Thanks,
Mike.

 

[RagDyer]

Check these Google links.

http://tinyurl.com/qvyp
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Peo:

I understand the sumproduct formula, but do not
understand how you use it here. Could you tell me what
the two dashes do for each array?

Thanks,
Mike.