subtotal

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

Hi I was reading the article below and the author said using Alt+= to activate the subtotal function? Why subtotal function has short key? do other functions have short cut keys? thank you. https://yodalearning.com/tutorials/subtotal-excel-formula-excel-advanced-filter-trick/

Pivot Table Subtotal, How do I change the subtotal column, my pivot table has approvers on column A, vendors on column B and the result of Sumiffs on column C, I want the subtotal by column A, but the pivot table subtotals by column B, that is just repeating on what is in column C. It is...

Hello All- I want to count all the "Yes", in a data range define as "CPR_Data", using the SubTotal function. Can anyone help?

Target: Blue Cell Q. I want to filter dates and derive the counts of the Item & Decision as a total. I want the total to change each time the date is filtered. So that's two criteria's based on which a total needs to be derived. ___________________________________________ I am at my wits end...

I am having issues writing a formula that will change the discount of a quote based on a subtotal. The Formula...

Hello, I hope someone can help me to solve the problem i came across. Below is the table with repetitive values in Column B and $ values in column C. I need to make a table of TOP10 positive and negative impacts without using pivot table or helper column. I made the table using getpivotdata...

Below is My COde But I am getting =SUBTOTAL(9,'B2':'B16') in the result cell

Hi Folks, I have a routine that takes a bunch of sheets in an array and performs a few actions including removing a subtotal. But what I'm noticing is if the active sheet in the loop does not have a subtotal I get 'RemoveSubtotal method of Range of class failed' error. Is it possible for...

I am trying to add or subtract a % (based on typing 5% or -5% etc) to a subtotal to get a new total. For instance, if in A10 I have a summed subtotal, I want to be able to type a positive % or negative % in A11. In A12 I want to total A10 plus or minus the % typed into A11. I hope that makes...

I'd like some assistance with calling the subtotal function on a worksheet(Sheet3) from another one(Sheet1). When I pass the spreadsheet onto my user the following message occurs: Run-time error '1004': Subtotal method of Range class failed. Let me start by stating that I don't know VBA...

Hello, can you someone please help me with this XML code? Attached is what the report looks like. I need help removing the waterfall subtotal, remove the subtotal in row 3 and 4. Fill down column A and B. Is that possible? Thank you in advance! Here's the current report definition in the tool...

Hi Has anyone noticed if AGGREGATE() processes data faster than SUBTOTAL() if you have a lot of data you are calculating? Thanks. Patriciaanne

Hi, I wonder if anyone could suggest anything - my macro runs desperately slow when it hits the operation to remove subtotal, delete entire rows with a number 1 (paste special values number not a formula) in a specific column and subtotal the data. I have approx 1500 rows but it seems to go...

I have this bit of code that creates a subtotal line: 'Add Total row Job Report Dim lastrow2 As Long lastrow2 = Cells(Rows.Count, "I").End(xlUp).Row Cells(lastrow2 + 2, "I").Resize(1, 31) = "=SUBTOTAL(9,I2:I" & lastrow2 & ")" With Range("I" & lastrow2 + 2...

Hello, Subtotal apparently only works for filtered data or manually hidden rows. I'd like to make a function in VBA that is basically just subtotal, but work for whatever might be hidden, rather than just rows. This seems to work as a test Sub subtest() Dim cl As Range Set cl =...

I'm trying to figure out excel VBA code to add subtotal (=SUBTOTAL(9,__:_) formulas to multiple Total Rows within a worksheet (red boxed. The issue is that the range for the subtotals can be any height. Per the image below, the hope is that the VBA code would be able to identify when "Total" is...

Hey All! Newbie to VBA, first time poster! Looking for help on how to write a VBA script that will delete subtotal groups equal to zero. We are implementing a new system and starting a new process for a goods received but not invoiced account and this will be a a way of reconciling the...