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