+ Reply to Thread
Results 1 to 2 of 2

COUNTIFS (3 Parameters) in filtered table

  1. #1
    Registered User
    Join Date
    06-08-2020
    Location
    Ho-Chi-Minh-City
    MS-Off Ver
    16.34
    Posts
    1

    COUNTIFS (3 Parameters) in filtered table

    Dear Excel Help Community,

    I am currently creating a excel file for my company to track social media post efficiency. To cut right to the problem:

    I have 2 sheets. The first sheet contains a weekly summary of posts per product/channel/week (the 3 parameters for the countifs function). The data for the countifs formula are on the second sheet.

    The formula itself works perfectly fine, however when I start to filter, the countifs formula sticks to the cell and not to the parameters anymore.

    Can anyone help me out? Let me know if you need any examples/ screenshots etc.

    Best regards,

    Duy

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: COUNTIFS (3 Parameters) in filtered table

    Always an example attach as per the yellow banner


    the below links may help, using the subtotal function if the filtering involves hiding rows, or perhaps more easily just using a pivot table


    https://exceljet.net/formula/count-v...-with-criteria
    https://www.excel-easy.com/data-****...ot-tables.html

+ 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] COUNTIFS with more than and less than parameters
    By Jon_Clay in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-18-2020, 05:23 PM
  2. Replies: 6
    Last Post: 03-19-2019, 09:14 PM
  3. Using COUNTIFS Filtered Data
    By CraigMcKee in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-27-2018, 08:36 AM
  4. [SOLVED] CountIfs when filtered
    By Lexian in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-12-2018, 08:14 AM
  5. how to write COUNTIFS in filtered table for shown data
    By aaaaa34 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-29-2016, 06:23 AM
  6. CountIfs on a Filtered list?
    By Thymoolean in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2013, 08:25 PM
  7. COUNTIFS filtered by month
    By HeathWilD in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2012, 05:06 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