Thanks Jacob and p45cal
Much Appreciated

"p45cal" wrote:


=SUMPRODUCT(MAX((X2:X5000=A2)*(Y2:Y5000)*(Z2:Z5000 =B2)*(Z2:Z5000<=C2)))

assumes B2 contains start date, C2 contains end date.
You may want to adjust the '=' and '<=' to just '' and '<' depending
on whether you want the dates in B2 and C2 to be included or excluded
from the result.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121906