Results 1 to 9 of 9

Count values of a defined range in a pivot table column

Threaded View

  1. #4
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2021
    Posts
    968

    Re: Count values of a defined range in a pivot table column

    On Sheet 1 you had a value error in J14 due to the length of cell I14 having 3 digits at the start. Corrected formula.
    I have inserted a count of the records which are between 0-30 minutes (including 0 & 30).
    Percentage does work of the un-filtered total, maybe not quite what you need.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot table to count values?
    By martinreed in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-24-2018, 09:32 AM
  2. Replies: 1
    Last Post: 11-19-2015, 10:34 AM
  3. Replies: 6
    Last Post: 08-19-2015, 07:46 PM
  4. How to count distinct values from table in pivot table
    By gopijadhav in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-04-2014, 07:14 AM
  5. Replies: 11
    Last Post: 07-18-2013, 05:14 PM
  6. Replies: 12
    Last Post: 02-06-2012, 11:23 AM
  7. Application defined or object defined error when creating a Pivot Table
    By Kaigi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-02-2009, 05: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