Afternoon all
I have a table of raw data containing an inventory list by department, I
need to count the number of items in each dept which are out of date.

I tried =SUMPRODUCT('Airlines Derby Dim and Inst
all'!B:B=Summary!A2)*('Airlines Derby Dim and Inst all'!L:L<17/6/2009).

Column B is the listing of all dept numbers and Column L is the date
information.
The summary sheet lists all the unique det numbers in column A.

I need to provide a count by dept with items containing dates before today
(17th June). Hope that explains it
Thanks in advance
Ajay