R Roger Govier Sep 27, 2005 #2 Hi Dawn Try =SUMIF(A7:A15,">=12/04/05",B7:B15)-SUMIF(A7:A15,">14/04/05",B7:B15) Regards Roger Govier