count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to count two colums if they both meet/match a curtain number.

Example if A1 = 2 and B1 = 12 then add one to the count.

The array that I am trying to count is two colums, A2:A800 and B2:B8000
 
To count the matches in COLUMNS A and B:

=SUMPRODUCT((A2:A800=2)*(B2:B800=12))


On Mon, 21 Feb 2005 13:07:06 -0800, d sweeney <d
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using CountIF function or Array? 3
count 2
Counting Multiple Text Cells 4
=COUNT(IF(AND(K2:K20>=382,K2:K20<=383),IF(E2:E20="x",1,0))) 4
How do I count # of cells with same value other column? 4
how do I count the number of times text in column A matches text i 2
Count if if 1
Conditional Formatting 2

Back
Top