subtotal

Hi, I'd like to be able to create custom subtotals for say Total Revenue based on other values. I'm using the idea from the video linked below to do this using a SWITCH function. The irony is the normal values pull through okay, it's the [Total Rev] value that doesn't, which is strange as the...

Hi, I have: SUMPRODUCT((tblStudentProgress[D3 Activity]=Satisfactory)*(SUBTOTAL(103,OFFSET(AW3,ROW(tblStudentProgress[D3 Activity])-MIN(ROW(tblStudentProgress[D3 Activity])),0)))) + SUMPRODUCT((tblStudentProgress[D4 Activity]=Satisfactory)*(SUBTOTAL(103,OFFSET(AW3,ROW(tblStudentProgress[D4...

Hi everyone, Is it possible to display the number of grouped items as a value or as a bracketed suffix to the name? For example: Accessoires would show "Accessoires (12)" and Accessoires Indoor would be "Accessoires Indoor (39)" even though it is collapsed. Alternatively, B3 would show the...

Hello Guys, I have a Pivot table, where i need to add new row above the pivot table and show the subtotal of each column till last available Column. (Pivot range may vary) Below is the code which i tried but it was not working correctly. Please help. LR = ActiveSheet.Cells.Find("*"...

Afternoon All I've cobbled together the following formula to give a Subtotal with multiple options when a column is filtered but it seems to be counting some things twice. I'm sure there is a far more elegant formula I could use but the one I am using is below...

Hey guys, I've recently started to use the sumproduct and subtotal functions to make my data responde to filters and after some struggle i made it work, but right now i can't use an expression that excludes by year. So i need an expression that gives me the number of dates in a column that...

Hey guys, I've been trying to use a countif expression that allows me to check for misplaced data, which is pretty easy, however it becomes a lot more tricky when i try to make that same data respond to filters. This is the expression i have used so far COUNTIFS('A...

I NEED SUbtotal with countif in Column D2 When i filtered in columnA give me 0 count in cell d2. ColumnA <colgroup><col><col><col></colgroup><tbody> ColumnB ColumnC Silver South-2 3 Silver South-2 3 Silver South-2 3 Silver South-2 0 Silver South-2 3 Silver South-1 3 Silver...

I'm using the Subtotal function, and that works good for what I'm doing, however, I don't need all the extra rows. Without the Subtotal function, I'm manually adding up the duplicate orders and then deleting the extra rows. Example Row 1: route 1 item D4 order 50 Row 2: route 1 item D4 order...

Hi, I've searched through 4 pages of "Subtotal" posts in this forum but didn't see one that covers what I need. I just want to have Subtotal values appear to the right of the column being sub-totalled rather than directly below each group of numbers. The col to the right would be created just...

hi all.. <tbody> data1 data2 data3 (Hidden) data4 data5 10 5 20 12 15 </tbody> how to use average formula with data hidden column.. i have use average or subtotal but not working. i'm use ms office 2010.. how to figure out this? I want can work for 2 condition, visible column or in hidden...

Good day everyone. I'm struggling to get my head around a bit of formula where I use a COUNTIF function, but have the result subtotal when a filter is applied. I have a list of values in column V; my code currently just looks in that range and counts the amount of times the values are equal to...

Hello everyone I'm currently working with a range of data that I need to subtotal, but after subtotaling I need to input formulas on the subtotal lines to reference the data in the subtotaled line one row above (the data filtered out). I'm currently using this for column A, but obviously this...

Hi everyone I have a table of data for users to filter as necessary, therefore instead of having a sum total at the last row of my table, I put in =subtotal(9,G4:G565) for about 10 columns. However when I filter the data, the last row with subtotal doesn't show after filter. Please have I...

Hi, I have a table with text and numbers that i got from MSProject, for example: <tbody> <colgroup><col span="2"></colgroup><tbody> A 36 A.1 10 A.2 12 A.3 14 B 61 B.1 38 B.1.1 15 B.1.2 11 B.1.3 12 B.2 11 B.3 12 </tbody> </tbody> My goal is to run a...

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

Hi, I'm using the function Subtotal on my Defined Name range. I would like to format the totals that come through, so that they stand out from the rest of the data. I would like to do this without necessary referring to exact rows/cells, so that the format will work even if the data changes. My...

Hi, I've got $ figures in range I14:T20, and each respective column has a subtotal formula=SUBTOTAL(9,I14:I20), =SUBTOTAL(9,J14:J20), etc The user can run a macro to insert a line at the bottom of the data which will then be populated with $ figures. My question is, when the row is inserted...

I created a Power Query table that has columns for Order#, Order Item#, Part#, Quantity, Item Value, Customer, Address, Order Status and Order Date. I see that the "Subtotal" menu option is greyed out. How to subtotal Item Values by Order# or by Customer like I would in a regular Excel...

Hello, I currently have a formula at the end of column P that shows the percentage of a particular entry in the column. =ROUND((COUNTIF(O2:O535,"Late")/COUNTA(O2:O535)*100),2) & " % Late" I've been asked to add subtotals to this sheet, AND to have this formula at each subtotal line. I'm...