subtotal function

Hi, I have inserted subtotals into a list of data by using subtotal function from the Data toolbar in Excel 2019. The resulting subtotals are not showing any "buttons" to filter the data to the various levels of subtotalling, only the subtotals after the various data splits. There is only one...

I have a spreadsheet (Office 365 version) that has 3000 rows. Column D has currency numbers, i.e., with 2 decimal places. Column B has Parent Account names. I need to apply a filter in the Parent Accounts column and correctly count the non-zero values in column D, i.e., get a subtotal count...

Hi, I have a Subtotal array formula that is applied to a range of filtered data. It works when the data is positive, however, it doesn't seem to work when the data is negative. {=MAX(SUBTOTAL(104,OFFSET(AH15,ROW(AH15:AH21739)-MIN(ROW(AH15:AH21739)),0,1,1))*(AH15:AH21739<=AH8))} Essentially...

I have expenses sheets where various columns of figures need to be totalled according to the filter criteria in the costs centre column. I had been trying the subtotal 9/109 function expecting that to work, but it seems you can only subtotal if the column is filtered on its own values. The...

I have a page that is subtotaled by day (with a Grand Total). I want to be able to add more days, subtotal and refresh existing grand total. How do I add more data to existing subtotals without removing, adding and resubtotaling? I am sure this is going to be a "Doh" moment but I cannot...

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

Hi all I have a worksheet containing thousands of numbers dates and times. All of which I have separated by inserting blank row after time value change. I now need the blank row to subtotal the cells between the two blanks. The number of cells is not the same between any of the blanks. Is...

Hi everyone, I have made a macro to add in a table a sub total from a filtered database. The sub total function being the only solution, because the SUM function is taking into account all the rows, and I only want the ones which are filtered. To do so, I have write this ...

Help please! I have a lengthy spreadsheet that uses the subtotal function so there are total rows on the spreadsheet. I would like to insert a formula only to the total rows that will show the results of subtracting two of the subtotals. Help?