| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i add numbers corresponding to same date on different work.
if i have dates ...suppose feb 14 with the 3 on one worksheet and feb 14,feb
15 with values on a different worksheet. i just want sum for each date |
|
#2
|
|||
|
|||
|
Hi Jay
one option you might like to check out is using Pivot Tables with multiple consolidation ranges - see the following web page for some details on this: http://www.contextures.com/xlPivot08.html Cheers JulieD "jay" wrote in message ... if i have dates ...suppose feb 14 with the 3 on one worksheet and feb 14,feb 15 with values on a different worksheet. i just want sum for each date |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date and time | New Users to Excel | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| How to stop excel replaceing numbers with the date? | Excel Discussion (Misc queries) | |||
| Converting numbers to date format from csv files | Excel Discussion (Misc queries) | |||
| Moving numbers from one sheet to another by date | Excel Worksheet Functions | |||
Linear Mode
