Greetings,
I am using the following:
=SUMPRODUCT(($D$27:$D$500=C12)*($G$27:$G$500=$K$2 )*($G$27:$G$500<=$K$3)*($H$27:$H$500="Single")*($B $27:$B$500))
where C12 is a depot, Single refers to a size, either Single, Part or Full
and Column B is the column to sum. K2 and K3 refer to a start and finish
date. The formula appears to work well but I wondered if it was possible to
include the dates in the formula?

Glenn