Hi,

The easiet way to sove this is to create a pivot table. Drag Data and Venue
number to the row area and score to the data area. Please the date and
venue in the row area depending upon whether you want to sum the score of
date by venue number or venue number by date

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"jdg" wrote in message
...
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