how do i add numbers corresponding to same date on different work.

[jay]

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

 

[JulieD]

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