View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default SUM (TODAY thru EOM)

Excel2003 ...

Range A2:A32 contains Days of Month (1-31)
Range B2:B32 contains Values

Cell B33 ... I wish to SUM Col B Values from TODAY thru End of Month.

ie: If TODAY is 04/18 ... Sum B Values 04/18 thru EOM
ie: If TODAY is 04/19 ... Sum B Values 04/19 thru EOM

Thanks ... Kha