SUM DATE on two worksheets
 

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.
--
barry

SUM DATE on two worksheets
 

Try this:

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

--
Biff
Microsoft Excel MVP


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