# COUNTIF formula problems. Excel 2010

#### impschocok

##### New Member
I am trying to write a formula that will count the number of due dates older than TODAY() so long as the corresponding cell in Column B is blank (not completed). So in the table below considering a today date of 9/5/2014, my formula should return 2. I have tried several COUNTIFS formulas but just cant get it to work.

 A B C 1 Due Date Date Completed 2 8/1/2014 7/25/2014 3 8/1/2014 4 8/1/2014 7/28/2014 5 8/1/2014 6 10/1/2014

<tbody>
</tbody>

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
maybe...

Excel 2012
ABCD
1Due DateDate CompletedCount
28/1/20147/25/20142
38/1/2014
48/1/20147/28/2014
58/1/2014
610/1/2014

<tbody>
</tbody>
Sheet2

Worksheet Formulas
CellFormula
D2=COUNTIFS(A2:A6,"<"&TODAY(),B2:B6,"")

<tbody>
</tbody>

<tbody>
</tbody>

Replies
5
Views
188
Replies
6
Views
224
Replies
4
Views
525
Replies
2
Views
250
Replies
11
Views
354

1,221,153
Messages
6,158,238
Members
451,477
Latest member
CWebbers

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