subtotal

Hello, I have a list where I need to get totals on cur. basis on top of the data as per the filtered account ( A1 ) basis. I need to type a formula in between E1 and E4 in curr. basis but , I do not know how I can run subtotal with if condition. Right side of the spreadsheet ( between column...

Hi, I have a table containing data that is refreshbale every month, my question is: is there a solution to do subtotal with power query? This is a link to the file and what I need https://www.cjoint.com/c/IAwk15tz46s Thanks very much

Hello, I have a report with a date slicer that returns, by sales manager, by sales rep, by account, the current period revenue and prior year revenue for the sliced date range. I need to add a column that counts the number of accounts with revenue in the current period. The data source is such...

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...