I have a worksheet that looks like this:

A B C D E F G
...............................
Date --- Line --- --- --- Value

01-Jan-08 ---- MR1 200
01-Jan-08 ---- MR1 100
01-Jan-08 ---- MR2 50
01-Jan-08 ---- MR2 75
01-Jan-08 ---- MR2 125

This is a very large database with four different (C column) types per date
and each type may have 1-6 entries. I want to be able to lookup the date and
sum the values for each C column type.

Can anyone help please?

N.B. The columns which are blank have info, however I don't need that info
right now.
Mike