$$Excel-Macros$$ Re: sumproduct and pivot table on same data ranges - different results - any reasons
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 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
$$Excel-Macros$$ Re: sumproduct and pivot table on same data ranges - different results - any reasons
I forgot to update values as i tried to make the size of the file smaller with less rows and columns ...on sheet4, line 28 should be the same as line 34 on sheet trt_june On 14 juil, 20:11, Pascal Baro 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
$$Excel-Macros$$ Re: sumproduct and pivot table on same data ranges - different results - any reasons
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 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