Hi,

Trust I explain this easily and someone can help.

My spreadsheet has three columns; date, unique venue ID number and a value -
eg

Date Venue Number Score Overall Score
1/1/09 1234 10 ??
1/1/09 1234 8 ??
1/1/09 6789 9 ??
4/2/09 1234 6 ??

I need a forth column to calculate the sum value for each venue based on the
same date as venues can have multiple rows with different scores for the same
date.
I don't mind if each row has the sum value figure for the same venue on the
same date as I can de-dupe based on date/venue number.

Any assistance greatly appreciated.

--
JDG