Way to speed up countifs using VBA?

Hi,

Thanks in advance for any help!

I have two large sheets of data in the format:

PHP Code: 

          2010  2011  2012
Person A    1   2   3
Person B    0   3   3
Person C    4   7   8
Person D    5   6   6 
etc 


I've attached a simple example workbook.

The same cell on each of the data sheets refers to the same individual in that given year. The numbers are codes for two different characteristics (Qualifications & years experience).

At the moment I am using the Countifs() formula on a third sheet to count how many people meet each of the criteria (i.e. how many people in 2010 have a 1 from the qualifications sheet AND 1 year of experience from the experience sheet, how many have a 1 AND a 2 etc)

This works fine but the problem is that I have 30 years (i.e. columns) and the number of rows is variable and dynamic (it could be up to 50,000 - representing 50,000 individuals). This is making the countifs formula VERY slow - it basically makes the workbook crash whenever I try to calculate.

So, is there a way to do all of this in VBA? I'm thinking a macro that would read the data from sheet 1 and sheet 2, perform the Countifs() function and then output that data onto a third sheet (it would be fine if I had to run this macro any time the data changed).

Again, thanks for any help.

Cheers,
Gareth