Counting cells with multiple conditions

**IvarZhukovsky** · 12-09-2011, 09:59 AM

Hi everyone,

Lets say my table has 3 columns and 1,000 rows. Column 1 has A, S, D, F and G entries; Column 2 has Q, W, E, R, T and Y entries. Information in Column 3 is not essential. Is there an easy way to count appearances of each value in Column 2 with every value in Column 1? I started filling in the DCOUNT formula, which works pretty fine to counting cells with multiple conditions, but there are a few more sheets with same data that I need to count and it will turn into a hell lot of formulas (6x5x4sheets+5SUM formulas= 125 formulas which is insane).

Would appreciate any help on this.

**ianh** · 12-09-2011, 10:13 AM

i think you want to use a =countifs() formula

**NBVC** · 12-09-2011, 10:30 AM

You can use a pivot table.

Drag first column to Row Labels, Drag second column also to Row Labels, then drag second column to Data (Summation) Values area.