Count cells with data in column F if within a date range in column A?

[Leesaugh]

I am trying to Count (or counta?) cells in one column if they have data but only if within a date range in another column.

So, in the example below, I would want to count how many cells in column E have data in them, but only if the date in column A falls between Jan 1 2014 and Jan 5 2014. (In this case, result should be 4).

A	B	C	D	E
01/01/2014				40
01/01/2014
02/01/2014				45
03/01/2014				40
04/01/2014
04/01/2014				65
06/01/2014
08/01/2014				40
09/01/2014				57.5

<tbody>
</tbody>

​

It seems like it should be so easy but I am stumped! Please help!

Thanks!

 

[jeffreybrown]

Maybe...

=COUNTIFS($A$2:$A$10,">="&DATE(2014,1,1),$A$2:$A$10,"<="&DATE(2014,1,5),$E$2:$E$10,">0")

 

[Leesaugh]

Thanks Jeff!