Hi all,

Solved my problem with the following
sumproduct((M2:M999=CellA1)*(M2:M999<=cellA2))

where cell A1 is the start date and cell a2 is the end date. Had to do it
this way because i am using the spreadsheet for more than one month and i
need stats for each month. The data may be entered in say the September but
it might not reach a conclusion for anything upto a year hence i have to keep
it in the loop.

Thanks for this new function I've just learnt I've also worked out how to
get the product to cover more than one argument - yeahhh!! (Can you tell I'm
new to this!)

In case anyone is interested - I wanted to count the number of times a
particular data set happened within any given month, but ONLY if they also
missed a 5 day deadline - my solution is

sumproduct(((M2:M999=CellA1)*(M2:M999<=CellA2))*( N2:N999=cellB1)*(N2:N999<=cellB2))

the first part is the selector for a given month, the second if its over 5
days but under 365 days

So far it seams to work with test data - can anyone see any flaw in this
function argument - please try to keep your answers for idiots as I'm still
getting used to what some of the terms actually mean!

cheers