subtotal countif

I am using countif(range,"TEXT") to get the total of my TEXT. Now, I have to filter them by year (2023 or 2024) and countif does not work for filtered column as it still gives me total numbers regardless of the applied filter. How do I count the number of my text in the filtered column please...

I need help adjusting the formulas in the 2nd picture attachment (Evaluate.jpg) so that they adjust when the data it is pulled from is filtered (by Role, Manager, etc.). I have figured out how to have the "rostered" calculations to update using =SUBTOTAL(2,Data[(Mon) START]) but I need help...

Hi, I have a data set like below and need to create a subtotal of the sections. I cant use the sum if function as the table will be filtered and need the section subtotals to be dynamic in line with the table filter. The filters are setup for BRAND,REGION,AREA and SITE. The idea is I have a...

I have a Spreadsheet/Dashboard that I created to look at sales trends YoY. I have created so many cells with formulas that now the spreadsheet takes forever to process between any changes. I essentially have 3 or 4 drop down boxes where I can select Region, Metric, Segments. What I'd like...

Hi Could somebody give me some assistance on how i could add a subtotal to allow me to use this Countifs function when filtering data? =COUNTIFS(Table2[0101-Interface Variation MF],">0",Table2[0101-Interface Variation MF],"<99.99") Thanks. Cailean.

<tbody> Content Category Random Content 1 A Random Content 2 B Random Content 3 A Random Content 4 B Random Content 6 B </tbody> Dear, I know this type of question has been addressed before but I was having problem understanding the multiple formulae used and how it could be applied...