Excel Tip Why Is My Pivot Counting Not Summing

++Read the Blog Post for this video here.http://www.howtoexcelatexcel.com/excel-tips-tricks/default-your-pivot-tables-to-sum-not-count ++Want to know more about Pivot Tables- Check out My Online Training Hub Online Pivot Table Course http://www.mothresource.com/152-27-1-41.html -------------------------------------------------------------------------------------------- ****SUBSCRIBE****** to my Excel at Excel newsletter 3 FREE Excel Tips every 15 days http://www.howtoexcelatexcel.com ----------------------------------------­-------------------------------------------------- ++Website http://www.howtoexcelatexcel.excel.com ++Twitter https://twitter.com/howtoexcelatex ++Pinterest http://www.pinterest.com/howtoexcelat If you use Pivot Tables then you will know the problem- I hope to help you with now. When you create your Pivot Table on certain columns of data, Excel will default to COUNT rather than the required SUM function. It is easy enough to change the function from COUNT to SUM but is there a way to default the data to SUM in the Pivot Table?. Well, not automatically but there us a quick way to ensure Excel will Pivot with SUM with some preparation of your data before you go to Pivot. Check out the Video to find out how. Or check out the blog post.