Count how many cells have data in one column if within a date range in another column?

[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!

 

[Marcelo Branco]

Try

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


M.

 

[Leesaugh]

Try

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


M.

THANK YOU SO MUCH!!! That worked perfectly! How about the same data, but this time I would like the sum of the numbers in column e based on the date in a.

 

[Marcelo Branco]

THANK YOU SO MUCH!!! That worked perfectly! How about the same data, but this time I would like the sum of the numbers in column e based on the date in a.

Try

=SUMIFS(E:E,A:A,">="&DATE(2014,1,1),A:A,"<="&DATE(2014,1,5))

M.

 

[Leesaugh]

Try

=SUMIFS(E:E,A:A,">="&DATE(2014,1,1),A:A,"<="&DATE(2014,1,5))

M.

Excellent. You are my hero today! Thanks!