+ Reply to Thread
Results 1 to 2 of 2

Countif Calculated field Excel problem

  1. #1
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Countif Calculated field Excel problem

    I want to only figure out the count of HM that equals 1, however, whenever I drag it to pivot table, TP Code count is always equal to HM(see below screenshot), I indicate the supposed result. HM Column consists of blank or 1 number if the condition meets on another column. How can I only count the supposed result?. I already used the calculated field but any count formula is not acceptable. Appreciate your help.

    Screenshot_7.jpg

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Countif Calculated field Excel problem

    We can't tell what's going on from a screen shot. Please see yellow banner at the top of the page and attach your actual file (it's easier to attach the Excel file than to take a screen shot and attach that).
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Replies: 2
    Last Post: 07-08-2017, 09:37 PM
  2. [SOLVED] Pivot table calculated field countif formula
    By IronCladRooster in forum Excel General
    Replies: 2
    Last Post: 04-22-2015, 01:49 PM
  3. Replies: 0
    Last Post: 10-24-2013, 10:59 AM
  4. [SOLVED] calculated field problem with subtracting
    By skinpup in forum Excel General
    Replies: 21
    Last Post: 12-22-2012, 04:27 PM
  5. Pivot Calculated Field Problem
    By B Glass in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2012, 11:29 AM
  6. 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
  7. PivotTable - Calculated Field Problem...
    By Sabotage1945 in forum Excel General
    Replies: 0
    Last Post: 02-17-2005, 12:23 PM

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