+ Reply to Thread
Results 1 to 3 of 3

Pivot table calculated field countif formula

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    Pivot table calculated field countif formula

    Hey I'm working with a table which, among other items, has a "performance figure". I need to put this in a pivot table (so as to group it by other categories) and then create a calculated field which counts the number of items that have a performance greater than 3, between 2-3, between 1-2 and below 1. Is that possible in Excel 2010?

    See attached for an example.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Pivot table calculated field countif formula

    One option may be to categorize the item first using IF function than pivot them.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    Re: Pivot table calculated field countif formula

    Quote Originally Posted by JieJenn View Post
    One option may be to categorize the item first using IF function than pivot them.
    Simple, yet effective. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using a MIN, MAX formula on a calculated field in a pivot table
    By fhaberland in forum Excel General
    Replies: 1
    Last Post: 01-20-2016, 06:07 AM
  2. [SOLVED] Edit the formula in a calculated pivot table field
    By dmascola in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-07-2013, 08:35 PM
  3. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  4. Pivot Table Calculated Field Formula Error
    By aharb in forum Excel General
    Replies: 0
    Last Post: 04-04-2012, 11:48 AM
  5. Using Countif in the Calculated Field of Pivot Table
    By coolzero in forum Excel General
    Replies: 0
    Last Post: 06-09-2010, 10:45 AM

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