Count rows which meet criteria

I am trying to count the number of rows that meet multiple criteria. For example if I had the following data

________A__________B____________C
1_______Eh_______04/01/07_______04/04/07
2_______Gb_______04/01/07_______04/04/07
3_______Eh_______04/01/07_______04/09/07
4_______Eh_______04/01/07_______04/06/07
5_______Gb_______04/01/07_______04/04/07

In the example above I want to be able to count the number of rows where there is an 'Eh' in column A and column C minus column B is <=7 (days). In the example I would want to return 2 (row 1 and row4).

Any guidance would be appreciated.

Thanks in advance.

Jonathan

Hi DomininB,

Thanks for your help. You pointed me in the right direction. It was not giving me the correct count with my 'real' data so I had to play around a bit. Eventually did the same as you but using the SUM function instead of COUNT.

Thanks again.

Jonathan