Thread: sum a range based on current financial year and client id
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default sum a range based on current financial year and client id
Excel 2007 PivotTable
YTD for selected clients.
Adjusted for financial (fiscal) (accounting) year.
No formulas, no code.
http://www.mediafire.com/file/mzzzzjfzm1t/07_04_09.xlsx
Excel 2003? You're out of luck.
Reply With QuoteReply With Quote