View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Sumproduct with nested if statement

Excel 2007
Pivot Table
Filter by month, quarter, date range, YTD,
group by ledger(s), department(s), values,
ignore empty cells,
all without a single formula:
http://www.mediafire.com/file/hwbygedtmvz/12_30_08.xlsx