It would simplify your problem greatly if you had the date in *every* Row
with data in it. You could then use SUMPRODUCT():
=SUMPRODUCT((A2:A8=DATE(2008,4,28))*(C2:C8=216)*D2:D8)

Signature
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk
> Hello
> I have a summing question. I want to, by day, sum the values in the 4th
[quoted text clipped - 24 lines]
> 2-May-08 Kifle 216 92 7.50
> Cathy 216 83 7.50
RichieK - 14 May 2008 15:21 GMT
Hi Sandy
Right after I posted I solved the problem simply using SumIf
> It would simplify your problem greatly if you had the date in *every* Row
> with data in it. You could then use SUMPRODUCT():
[quoted text clipped - 29 lines]
> > 2-May-08 Kifle 216 92 7.50
> > Cathy 216 83 7.50
Sandy Mann - 15 May 2008 00:27 GMT
As long as you found an answer - that is the important thing

Signature
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk
> Hi Sandy
> Right after I posted I solved the problem simply using SumIf
[quoted text clipped - 34 lines]
>> > 2-May-08 Kifle 216 92 7.50
>> > Cathy 216 83 7.50