+ Reply to Thread
Results 1 to 3 of 3

Pivot-automatic sum on values

  1. #1
    Registered User
    Join Date
    02-02-2011
    Location
    Los Angeles, Ca
    MS-Off Ver
    Excel 2010
    Posts
    11

    Pivot-automatic sum on values

    I use Pivot and values automatically go to "count" instead of "sum". Is it possible to automatically set it to go to "sum"?

    Thank you

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    14,419

    Re: Pivot-automatic sum on values

    Hi,
    It will automatically go to sum if all the data in the column you drag down to the summation area are values. If the Pivot Table finds a single blank or non numeric data it defaults to count. This has been my experience but read the following article.

    http://www.pivot-table.com/pivot-tab...o-sum-or-count
    One test is worth a thousand opinions.
    Click the * below to say thanks.

  3. #3
    Registered User
    Join Date
    02-02-2011
    Location
    Los Angeles, Ca
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Pivot-automatic sum on values

    Thank you so much for your response Marvin. I don't remember if there is a blank but I am sure they are all numeric data. I will surely read the link you included.
    Best regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1