+ Reply to Thread
Results 1 to 6 of 6

Count based on a colum and slicer in table

  1. 03-18-2021, 06:56 PM #1
    qzucule
    qzucule is offline
    Registered User
    Join Date
    11-29-2018
    Location
    Maputo
    MS-Off Ver
    2016
    Posts
    3

    Count based on a colum and slicer in table

    Hi,

    I am having an issue to count items grater than 0 (zero) in a colum based on slicer selection in a table. Because ehen i use =COUNTIF(Sales_Team[Salary],">0") the number does not change even afterselecting the filter of the region.

    I Attached the excel file and indication of the formula.

    Regards

    QZ
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-18-2021, 10:48 PM #2
    Adtxc
    Adtxc is offline
    Registered User
    Join Date
    01-11-2021
    Location
    CANADA
    MS-Off Ver
    Excel 2007, Office 2019
    Posts
    31

    Re: Count based on a colum and slicer in table

    =SUMPRODUCT(--(SUBTOTAL(2,OFFSET(Sales_Team[Salary],ROW(Sales_Team[Salary])-ROW(C6),0,1))),--(Sales_Team[Salary]>0))
    Reply With QuoteRegister To Reply
  3. 03-18-2021, 11:45 PM #3
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,625

    Re: Count based on a colum and slicer in table

    Slicer not required
    B3 is validated.
    In C3

    =SUMPRODUCT((Sales_Team[Region]=B3)*(Sales_Team[Salary]>0))
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  4. 03-19-2021, 03:51 AM #4
    vikingator
    vikingator is offline
    Registered User
    Join Date
    03-19-2021
    Location
    poperinge
    MS-Off Ver
    2020
    Posts
    11

    Re: Count based on a colum and slicer in table

    =SUMPRODUCT(--(SUBTOTAL(2,OFFSET(Sales_Team[Salary],ROW(Sales_T
    Reply With QuoteRegister To Reply
  5. 03-19-2021, 03:53 AM #5
    qzucule
    qzucule is offline
    Registered User
    Join Date
    11-29-2018
    Location
    Maputo
    MS-Off Ver
    2016
    Posts
    3

    Re: Count based on a colum and slicer in table

    * Thank You for your help it worked!!!
    Reply With QuoteRegister To Reply
  6. 03-19-2021, 05:10 AM #6
    qzucule
    qzucule is offline
    Registered User
    Join Date
    11-29-2018
    Location
    Maputo
    MS-Off Ver
    2016
    Posts
    3

    Re: Count based on a colum and slicer in table

    Thank You very much.

    That was exactly what i wanted.

    Congrats!!!!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count Colum F based on certain text
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-06-2017, 08:45 AM
  2. code that will count the number of items selected in a slicer on a pivot table
    By asmi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2017, 12:57 AM
  3. What formula to count total student based on 4 different colum
    By redza in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2014, 12:04 AM
  4. Count based on multiple colum values
    By robin_108 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-09-2012, 11:56 AM
  5. Count Unique in one colum based on matches in other Column
    By ExcellentM in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 03:22 PM
  6. [SOLVED] Colum count based ón values In colum a and b
    By 2001jesper in forum Excel General
    Replies: 16
    Last Post: 11-05-2012, 03:28 PM
  7. If statement based on if Any value in a given colum matches a text value in a table.
    By nineismine in forum Excel General
    Replies: 1
    Last Post: 04-24-2009, 03: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1