CountIf for multiple colums

  • Thread starter Thread starter Jacques
  • Start date Start date
J

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:

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.
 
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.
 
Back
Top