+ Reply to Thread
Results 1 to 2 of 2

Pivot - Counting only Single Cell Status

  1. #1
    Forum Contributor
    Join Date
    12-13-2011
    Location
    Yorkshire, UK
    MS-Off Ver
    Office365
    Posts
    183

    Pivot - Counting only Single Cell Status

    I'm trying to put together a pivot that tracks the amount of actions that are still open from a pivot. The field has the options of 'open' or 'closed' and I only want to count those that are open but I'm having difficulty in only counting the 'opens'. How do I get excel to do this?
    Attached Files Attached Files

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,980

    Re: Pivot - Counting only Single Cell Status

    Select a cell in the pivot table, click the Insert tab, and choose Slicer, linking it to the Status tab, then just select Open in the slicer.
    Everyone who confuses correlation and causation ends up dead.

+ 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] Counting values in single cell - Macro
    By avon9321 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-07-2017, 04:37 PM
  2. [SOLVED] Counting Dates in a Single Cell
    By Rol.S in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 10-09-2016, 07:39 AM
  3. Counting Unique Characters Within a Single Cell
    By camsbigblue in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-15-2015, 07:26 PM
  4. [SOLVED] Counting Numbers within a Single Cell
    By VT_2000 in forum Excel General
    Replies: 5
    Last Post: 05-02-2012, 06:23 PM
  5. Replies: 4
    Last Post: 04-08-2012, 09:43 PM
  6. Counting multiple values in a single cell
    By ac8038 in forum Excel General
    Replies: 8
    Last Post: 06-20-2006, 09:30 AM
  7. Counting values and comparing them to a single cell
    By Tbentsen in forum Excel General
    Replies: 3
    Last Post: 08-04-2005, 06:05 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