Sorry every who read this post, The mistake is not located on the productsum table or on the pivot table. It's simply located in the table below the productsum table which as an incoherent formula (it takes twice a value) which makes the difference...sorry
On 14 juil, 20:11, Pascal Baro <bpascal...@googlemail.com> wrote: > Please find a file attached for more on this query. > Thanks > > sumproduct_pivot_table.xlsx > 668KAfficherTélécharger -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
