thank you very much for your response

alison

"Andrea Jones" wrote:

Assuming your start date is in E1 and your end date in F1 and the data is in
cells A2 to B50 you could use:

=SUMPRODUCT((A2:A50=E1)*(A2:A50<=F1)*(B2:B50="Del ivered"))

Andrea Jones
www.allaboutclait.com


"alistew" wrote:

Hi

i have a worksheet with 2 columns of data. column a has dates and column b
has text (delivered or not delivered). i want to count the number of
instances of the word delivered between a certain criteria of dates. ie
01/01/09 and 31/01/09. The dates are in a start date and end date cell and
will change.

Appreciate any help.

Regards
ali