View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bri123321 Bri123321 is offline
external usenet poster
 
Posts: 3
Default YEAR TO DATE SUM

Working on a financial spreadsheet that adds columns to get a YTD total. The
columns are setup Actual, Budget, Actual, Budget, Actual, Budget etc. for the
year. I can use the sum function for the actuals but wondered how to sum the
budget columns to only include those months corresponding to the # of months
I'm summing for Actuals to arrive at a YTD comparison.