# CountDates

#### balcardi_uk

##### New Member
hi

this is my sample table

A = name B = dob C = location
jane 01/01/2005 london
terry 01/01/2005 cardiff
david 02/01/2005 london
tracey 01/01/2005 london
harry 19/01/2005 london
mike 19/01/2005 swansea

=COUNTIF(B4:B100,"<" & TODAY())
The above formula counts how many in babies were born before current day.
But i need to know how many babies were born before current day AND were born in london. The letters next to headings denote column letters. I hope someone can help!!!

cheers

Balcardi

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

#### tactps

##### Well-known Member
Try:
=SUMPRODUCT(--(B\$8:\$B\$13<TODAY()),--(C8:\$C\$13="london"))

#### MycroftII

##### New Member
Type

=SUM((B4:B10 < TODAY())*(C4:C100="london"))

and press CTRL+SHIFT+Enter

#### tactps

##### Well-known Member
Sorry, post is worng (don't know what happened):
=SUMPRODUCT(--(B\$8:\$B\$13<today()),--(\$C\$8:\$C\$13="london"))

Adjust the ranges to suit, but make sure they are the same length (ie all of mine are from row 8 to row 13)

##### MrExcel MVP
=SUMPRODUCT(--(DOBrange < TODAY()),--(LocationRange = "London"))

#### balcardi_uk

##### New Member
Thanks everyone u've all been excellent, I've got it sorted
Proper BO!!!

Replies
6
Views
197
Replies
5
Views
332
Replies
9
Views
996
Replies
0
Views
563
Replies
0
Views
390

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,152,115
Messages
5,768,204
Members
425,459
Latest member
Danniey

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