Count Dates in a range based on Column Header Id without using sum-product

Hello All,
I want to use the countif function to count dates in a range based on Column HEADER at the Top. For example I want to count all X005 between 01st and 10th of May, 2012.
I am looking for a dynamic countif function using look up formula which could be replicated for other IDs like X006, X007 without highlighting the column number.
The problem is 2-fold:
1. Select column X005
2. Count dates between 01st and 10th of May

So, Once I copy over this formula in the cell below it would populates the count for X006

I do not want to use sum-product as it takes up lot of memory and freezes excel if i try to change a date.

The Data is shown Below: ( Actual Data runs 1000s of lines)

ID X005 X006 X007 X008 X009 X010 X011
A001 25-May-12 2-Jul-12 28-Sep-12 18-Jun-12 6-Jul-12 9-Sep-12 25-Aug-12
A002 25-May-12 2-Jul-12 28-Sep-12 18-Jun-12 6-Jul-12 9-Sep-12 25-Aug-12
A003 25-May-12 2-Jul-12 28-Sep-12 8-Jun-12 6-Jul-12 17-Sep-12 25-Aug-12
A004 25-May-12 2-Jul-12 28-Sep-12 29-Jun-12 6-Jul-12 17-Sep-12 25-Aug-12
A005 25-May-12 9-Jul-12 4-Oct-12 8-Jun-12 13-Jul-12 16-Sep-12 31-Aug-12
A006 25-May-12 9-Jul-12 4-Oct-12 11-Jun-12 13-Jul-12 16-Sep-12 31-Aug-12
A007 02-May-12 9-Jul-12 4-Oct-12 14-Jun-12 13-Jul-12 16-Sep-12 31-Aug-12

Kindly let me know if this is possible. I appreciate all the help in this regard.

Thanks
Sam

Try this way:

=COUNTIFS(INDEX(A:H,0,MATCH("X005",A1:H1,0)),">"&N3,INDEX(A:H,0,MATCH("X005",A1:H1,0)),"<"&N4)

where N3 holds 1st date and N4 holds second date - also change the "X005" references to a cell address that holds that value

Works like a Charm. Appreciate the Quick Response. I knew it had to something with Index function...but just could not figure it out

We're glad to have helped. Please remember to mark your thread as SOLVED (click Forum Rules @ top of page to see instructions in rule #9).

Is there a way to combine the 2 criteria? Any thoughts? Thanks for the help.