| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| renaming worksheets by date value | Excel Discussion (Misc queries) | |||
| auto date changing on worksheets | Excel Discussion (Misc queries) | |||
| date from multiple worksheets | Excel Worksheet Functions | |||
| link a date between two worksheets. | Excel Discussion (Misc queries) | |||
| Collating date from a number of worksheets into one | Excel Discussion (Misc queries) | |||
Linear Mode
