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
Bookmarks