View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geebee geebee is offline
external usenet poster
 
Posts: 190
Default sum certain columns

hi,

i have a sheet with severasl rows in it. each row corresponds to a certain
month and year. ranging from jan-04 through mar-08. i would like to add a
new column to the worksheet, and have it have a formula for the YTD sum. so
how can i make it to where the new column only adds the amounts for months in
the current year? can this be programatically done?

thanks in advance,
geebee