Database Functions - question using formulas as criteria
 

Hi,

I've been trying to get my head around Database function in Excel.

I have a list of data, one of the fields is the number of days between two
dates. Using COUNTIF I'm able to provide a table of the distribution of
days - E.g. =COUNTIF(Days,C5) Where C5 contains the number of days I wish to
count on and "Days" is a column in my table.

However the problem with this is that it counts for all values in that
range. I have another field (named "Emptied") which contains a date. I'd
like to be able to provide the analysis based on the year of the rows
"Emptied" date. E.g. Instead of "count of number of days in "Days" range
which = X", I'd like "count number of days in "Days" range which = X and
which the year of the Emptied column = 2005."

I gather I need to DCOUNT but I'm a bit foxed as to how to achieve it...

Any pointers?

Kind thanks

Chris.