How to count occurrence when there is an "AND" relation?

  • Thread starter Thread starter Rose
  • Start date Start date
R

Rose

I want to count the occurrence of a particular combination and the result
will be a 2D matrix. countif, sumif or using array formula, vlookup or
combining usage of AND function did not work, would anybody have any idea to
solve the problem?

A B D E F G
0 1 2
0 1 1 14
0 1 2 13
0 1 3
0 1 4
....
0 2
0 2
....
1 1
1 1
....
4 2
 

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

Count without SUMPRODUCT 1
Can you use an INDEX array in a COUNTIF formula ? 1
Bugs in vlookup? 0
SUMIF to sum multiple columns of data? 2
total point 5
counting absentees 1
Your help please in updating a column using Count or an Array Formula 3
count if the cell contains a word found in another cell 2

Back
Top