Counting cells with numbers between dates

[Chris Tucker]

I am needing a little help with something that is probably pretty basic. I need to know how many cells have a value based on a range of dates

Date	value after date	1/3/16	1/10/16	1/17/16	1/24/16	1/31/16	2/7/16	2/14/16	2/21/16	2/28/16	3/6/16
1/22/16	3	1	21	6		8	2	3
2/16/16	2				6	5	8		3	2

<tbody>
</tbody>

Looking at the table above I need the values to show up in red. I need to search the date range A3:A12 and count the cells in row B that have values above the date in B1

 

[63falcondude]

How's this?

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L
1	Date	value after date	1/3/2016	1/10/2016	1/17/2016	1/24/2016	1/31/2016	2/7/2016	2/14/2016	2/21/2016	2/28/2016	3/6/2016
2	1/22/2016	3	1	21	6		8	2	3
3	2/16/2016	2				6	5	8		3	2
Sheet1

Cell Formulas
Range	Formula
B2	=SUMPRODUCT(($C$1:$L$1>A2)*(C2:L2<>""))