LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MH MH is offline
external usenet poster
 
Posts: 28
Default ytd totals for multiple years

Hi,
In column A i have the month formatted as mmm-yy
In colums B, C, D,E and F I have values for different categories. In some
cells, starting at P4 for example. I would like to get YTD totals for columns
B,C etc. I would like to be able to simply enter my values in B,C, etc and
P4 updates such that when I enter the values for Jan of a new year the YTD
total starts over by itself. Any ideas?
Thanks for the time and effort.
-Matt
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to link multiple columns to multiple worksheet totals / functi Chieftan Excel Worksheet Functions 4 June 23rd 09 10:11 PM
Creating stacked bar for multiple groups and multiple years James Charts and Charting in Excel 2 November 14th 08 05:18 PM
same month/day on x axis for multiple years mjo73 Charts and Charting in Excel 1 January 15th 06 06:18 PM
synchronizing the years for multiple dates Bob Phillips Excel Discussion (Misc queries) 0 October 25th 05 08:16 PM
synchronizing the years for multiple dates Dave O Excel Discussion (Misc queries) 0 October 25th 05 08:03 PM


All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"