View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PamelaJ PamelaJ is offline
external usenet poster
 
Posts: 1
Default Sum data between 2 dates ie 01Jun-30Jun


I'm trying to sum information on another worksheet.

01-Jun in column a and 15 in column b
25-Jun in column a and 20 in column b
01-Aug in column a and 30 in column b

to give me total for Jun in another worksheet with a total value of 35
(ie adding just the month of June

Can anyone help?


--
PamelaJ
------------------------------------------------------------------------
PamelaJ's Profile: http://www.excelforum.com/member.php...o&userid=36387
View this thread: http://www.excelforum.com/showthread...hreadid=561701