Adding a condition to a formula to filter data

I am using Excel 2007 at work. I want to add a condition to a formula that updates a cell in another worksheet (in the same workbook) if an entry is made within a specific month. So... I currently have the following formula;
=(A4-E4)/365
'A' = current system date, 'E' = input date of birth - This formula calculates current age and returns it to 'F'.
'C' is date of record entry.

=COUNTIF('Data input'!F$4:F$1003,">=16")-COUNTIF('Data input'!F$4:F$1003,">=18") - this formula splits the returned data on a separate worksheet into a range of ages. What I need to do is add a condition that only counts them if 1) the conditions in the COUNTIF formula are met AND the entry is on a specific date. I tried;
=COUNTIF('Data input'!F$4:F$1003,">=16")-COUNTIF('Data input'!F$4:F$1003,">=18")-COUNTIF('Data input'!C$4:C$1003,">=01/04/2013")-COUNTIF('Data input'!C$4:C$1003,">=30/04/2013")

I get a return of '0' but on inputting today's date, where it should change to '1', I get nothing...
Any help appreciated

The relevant sheets are; Data input and Report Monitoring...

Attachment 228380

Hi Lem
The sumproduct is certainly returning a number in the cell. Does it automatically change from month to month or do I need to configure the formula for each of the cells where I need a different monthly answer...? What I was looking to do is report back on a monthly basis on the changing figures- 30 April would report all those who had registered in April, 30 May would report those in May and so on... I would also have a cumulative yearly total which would simply be the product of all those totals...
Martin

Doh! Is the '4' on the end of the formula a clue?

That works... one more question, if I may (which is related).
On the age ranges, I have;
16-17 (but under 18)=COUNTIF('Data input'!F$4:F$1003,">=16")-COUNTIF('Data input'!F$4:F$1003,">=17")
18-21 (but under 22)=COUNTIF('Data input'!F$4:F$1003,">=18")-COUNTIF('Data input'!F$4:F$1003,">=21")
22-24 (but under 25)=COUNTIF('Data input'!F$4:F$1003,">=22")-COUNTIF('Data input'!F$4:F$1003,">=24")
25-49 (but under 50)=COUNTIF('Data input'!F$4:F$1003,">=25")-COUNTIF('Data input'!F$4:F$1003,">=49")
50-64 (but under 65)=COUNTIF('Data input'!F$4:F$1003,">=50")-COUNTIF('Data input'!F$4:F$1003,">=64")
65+(nominally under 100)=COUNTIF('Data input'!F$4:F$1003,">=65")-COUNTIF('Data input'!F$4:F$1003,">=100")
Would this reflect the right data sets or would I need to encompass the ages differently e.g. 16-18, 18-22 and so on?
Probably a dopey question...
Martin

Lem... You are a STAR!!!!

Uhhhh.... Lem?
Sorry my friend but I tried to adapt the formula so that I could capture other numbers such as 'male/female/transgender/not disclosed' by changing it to;
=SUMPRODUCT(--('Data input'!G4:G1003>="Male"),--('Data input'!G4:G1003<"Male"),--(MONTH('Data input'!C4:C1003)=4))
I made a boo boo somewhere I think...
Any suggestions?
M