Counting cells with multiple conditions

[IvarZhukovsky]

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.