Thread: PivotTable Row Count
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 PivotTable Row Count
Use Excel 2007 instead of 2003
Use SUMIFS() instead of SUMPRODUCT()
10 times faster.
http://www.savefile.com/files/1683239
Reply With QuoteReply With Quote