COUNTIF problem

Hello,

I cant quite figure this out...

I have a table that has Column A "Date of birth", Then for each milestone at Column B, C, D

I want to count the number of people based on year of birth that have achieved all 3 milestones in B, C, and D only (column B, C and D all have dates if completed, and I don't want to count the blanks or N/A's)

I've used =COUNTIFS(Sheet1!A:A,">=1/1/2014",Sheet1!A:A,"<=31/12/2014") to get only those born in 2014 but how do I go about the rest?

Thanks for your help!

Attach a sample spreadsheet with expected results, remove any sensitive data.

Try

=COUNTIFS(Sheet1!A:A,">=1/1/2014",Sheet1!A:A,"<=31/12/2014",Sheet1!B:B,">0",Sheet1!C:C,">0",Sheet1!D:D,">0")

edited to correct typo and remove some stupid I forgot that using ">0" doesn't count text in countif.

Split the task up, add some helper columns.

One column for the DOB Year, and another column to COUNT the number of values (dates) entered in B-D.

Then you can use a simple COUNTIFS over both these columns.