I want to create a SUMIF function but I only want it to return the value of
items within and inclusive of 2 dates. e.g the sum of column C if column A
has dates between 01/07/06 and 30/09/06 inclusive.

Similarly I want to create a COUNTA function for the same criteria.

I am using Microsoft Excel 2003.