Here are some problems that our users have asked and received explanations on
I used the this formaula=IFS(SUBTOTAL(2,F8:F92),COUNTIF(F8:F92,"3")) but the count if "3" is not changing the subtotal numbers while doing filtering
Solved by G. Q. in 29 mins
Hello, I am trying to do a countif with a subtotal, can you help please?
Solved by V. D. in 24 mins
Need help with excel assignment. Need to add column Subtotal. Calculate Subtotal.
Solved by Z. H. in 21 mins
When I link cells to another excel ss, and the second ss is subtotalled, the subtotal expands and I don't know how to keep the subtotal collapsed.
Solved by E. Q. in 21 mins
hi, i have this formula =SUMPRODUCT((B4:B464<>"")/COUNTIF(B4:B464,B4:B464&"")), i want to add a subtotal to it. so when I filter the column it also sums up the unique number if enteries i have filtered on.