subtotal

I have this vba code below that I'm using to count, but I would like to use subtotal to count the number of visible filtered data. Can someone assist? Thank you kindly. CCP.Caption = WorksheetFunction.CountIfs(Range("D15:D" & LRow), ">=" & "01/01/" & cbYr, Range("D15:D" & LRow), "<=" &...

Hi All, I've been working at this for the better part of this morning. No matter what I try, I cannot make this formula work without using the volatile OFFSET formulas nested in this formula. So, I'm coming for help. What I'm doing is looking at inventory and the comparing it to monthly...

I have a table of data that I need to then auto filter to return a subtotal across 11 columns and the works fine, however what I would really love is a front page to this data that automatically displays set criteria I would normally select to auto filter by. For example when I auto filter to a...

I have a bunch of TEXT statuses that I am taking count of. The Statuses are in K, Count of all in L and would like to count filtered in M. In the L column I have a working =COUNTIF($L$11:$L$2000,K2) =COUNTIF($L$11:$L$2000,K3) etc. But I am now trying to do a COUNTIF with SUBTOTAL which is...

Hi, I got this formula idea from an old thread here. I successfully got the formula to work, but it's very slow. Is there a simpler process? =IF(A2="","",SUMPRODUCT(SUBTOTAL(9,OFFSET('Partner Planner'!C2,ROW('Partner Planner'!$C:$C)-ROW('Partner Planner'!C2),0)),('Partner...

I would like to adjust the formula below to not restrict the range. I like to subtotal until the last non empty row when I filter. ="Company ("& SUBTOTAL(3,A15:A1000) & " of " & COUNTA(A15:A1000)&")"

Alright so I have a chart in which I need to do some deviations with a single criteria. Problems is the filtering involved and therefore subtotal, sumproduct and other complicated functions are involve. Here is an excel chart I just made to illustrate my dilemma...

I am trying to figure out how to resize a range so I can format subtotal lines via a loop. I have no problems with the loop but I am really confused on how the range resize works. I am searching column F for the word "Total". If that cell contains that word then select columns A to O in that...

Pivot table subtotals - is there a way to only subtotal those lines with more than one row? Any help so much appreciated! :) https://drive.google.com/file/d/1Matxoa6iOn4N6IquwD0nfa3aWIJ9Fzs8/view?usp=sharing

Hello all, I'm completely new to pivots in general, but it seems like my expectations are already leading me to look for something more advanced than my knowledge would allow. My source of data is a list of products and their weekly rankings. My pivot table shows product's ranking on weekly...

Currently I have a column of data with Yes, No, N/A (I have converted these to blank cells so they are ignored) as the possible answers. I have been able to calculate the % of 'Yes' answers using the Formula: =COUNTIF(A2:A103,"Yes")/COUNTA(A2:A103) I would like the % of 'Yes' responses to...

Hello, I'm having some difficulty with the SUBTOTAL function. I'm looking to find the sum of a range within a filtered spreadsheet. I entered =SUBTOTAL(9,[RANGE]) and it returned an answer of 7.10543E-14 (which doesn't make sense since my values on have two decimals). I calculated it manually...

In cell E88 I have the formula =SUMPRODUCT(B84:B86,E84:E86) In cell E121 I have the formula =SUMPRODUCT(B92:B119,E92:E119) and so on for many other subtotal cells in the E column. I would like to incorporate all the Sumproducts into Subtotals so I can add up all instances of the Sumproducts...

Ok I have looked at advanced options on each tab to make sure they are the same so now I'm stumped. I have a large worksheet that has main data tab and 2 supporting tabs that sort by different measurements. When one tab fiters by customer the supporting colums subtotal as you change customers...

Hi, Have a report, totals represented in cells b3:ac3. I need to hide columns at times and would like the subtotals. I tried this thread but can't get it to work. Can anyone help? https://www.mrexcel.com/forum/excel-questions/655374-subtotal-column-hiding.html

I want to count distinct stock numbers J4:J1226 I'm using formula =SUMPRODUCT(1/COUNTIF(J4:J1226,J4:J1226)) and it works pleasantly. Now I want to add one more problem. When I filter out perhaps stock numbers worked by a particular person I want it to return a count distinct subtotal. I can...

Hi let say I have A1:A10 column. Lets say I did filter to that column. My question, which range I should use in my subtotal function. The one before the filter (A1:A10) or after the filter? Also I just noticed that subtotal can take more than 2 arguments! function #, ref1, ref2 etc what ref2 is...

Hi Let say I have A1:A100 column. I want to find the subtotal. I filtered column A and now I have 20 cells. Should use subtotal before filtering the column? I mean to select A1:A100 or after filtering the column and then select the 20 cells left? I tired it both, sometime both work but some...

Hello, I have a table that is growing with each day to the RIGHT. Column data are numbers And at one point i want to hide some columns and make a sum of the columns that remain. But Subtotal only works with rows. Is there a way to make: =SUBTOTAL(109;A2:F2) - this one is not working...

Hello, and thank you for reading this post. I'm creating an org chart outline to account for employees during an emergency. The goal is to associate each supervisor (Reports To) with subordinate staff(Name) that reports directly to that supervisor. From this table check lists will be created to...