+ Reply to Thread
Results 1 to 2 of 2

Selecting certain data using IF statements in pivot table

  1. #1
    Registered User
    Join Date
    06-11-2019
    Location
    houston, tx
    MS-Off Ver
    2016
    Posts
    1

    Selecting certain data using IF statements in pivot table

    Hello, I am currently using a pivot table to organize my data. I want take the average of certain numbers in a column only IF the column next to it corresponds to FALSE. Is this possible? For example:
    A1(NUMBERS) A2(USE)
    2 FALSE
    3 TRUE
    5 FALSE

    So I only would want to take the average between 2 and 5. Thank you so much!

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Selecting certain data using IF statements in pivot table

    Do you mean 2 THROUGH and including 5 OR just the value of 2 and the value of 5?

+ 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. Pivot Table - Selecting only Specific Columns of Data to Pivot
    By newqueen in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-17-2019, 04:49 PM
  2. Selecting Column Data in Pivot Table (from Data model)
    By derickz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2016, 11:35 PM
  3. Pivot Table Not Selecting Max Week
    By rbirch in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-25-2015, 04:37 PM
  4. selecting pivot table items
    By verschelde.steven in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2014, 03:24 PM
  5. Cache of Pivot table is not selecting the table values
    By Menaka in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-06-2013, 07:39 AM
  6. Macro for selecting a single item while filtering the data in Pivot Table
    By Syed964 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 01:28 PM
  7. Replies: 0
    Last Post: 03-22-2009, 07:17 PM

Tags for this Thread

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