I have searched for the answer to this all over today and although I have seen somethings that may help me, I dont understand them or they dont quite cover what I need.

I have a worksheet called Test.

It has 3 columns.

Column A contains only dates in the DD/MM/YYYY format.
Column B may have text in the cells or it can be empty.
Column C may have text in the cells or it can be empty.

I have another worksheet called Totals.

This will show the results of a search based on certain criteria.

A1 is where the first 'from' date criteria is entered.
A2 is where the second 'to' date criteria is entered.

In A5 I have entered the correct formula to count how many cells have the dates that fit the criteria in A1 and A2. So if I type 01/01/2009 in A1 and 01/02/2009 in A2, it returns the numbers of cells that have a date between those two dates.

What I now need is the formula that will count the numbers of cells with text in either column B or column C that match the date criteria.

So A5 will have the total cells between the dates entered (For example it may return 9), A6 will say how many of those 9 have text in Column B and A7 will say how many of those 9 have text in column C.

It is possible for all 9 to have text in column B and column C so A5 could show 9, A6 will show 9 and A7 will show 9, but that doesn't matter.

Is this possible?