SUM DATE on two worksheets

[barry]

I have two worksheets - 1st one is Played 2nd one is Score
in first work sheet i have columns n "points" column o "date" in worksheet
two i have column c where i enter the played date and then in column d i want
to add up the points for that particular date from the previous worksheet.
Can excel do this type of calculation?. Thank you.

 

[T. Valko]

Try this:

=SUMPRODUCT(--('Played 2nd'!O$2:O$20=C2),'Played 2nd'!N$2:N$20)