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

#### Leesaugh

##### New Member
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>

Thanks!

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### jeffreybrown

##### Well-known Member
Maybe...

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

#### Leesaugh

##### New Member
Thanks Jeff!

Replies
4
Views
154
Replies
6
Views
582
Replies
5
Views
520
Replies
2
Views
273
Replies
12
Views
556

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,875
Messages
5,834,182
Members
430,263
Latest member
abz54

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back