1. M

    Subtotal by Funding on one sheet but put the results on another sheet

    What I'm trying to do is create a macro that does the following: 1. On the "By Transaction" worksheet sort by the Funding column . 2. Subtotal by Total Amount Due by a change of Funding 3. Copy the Funding and Total Amount Due Subtotal onto another sheet "By Funding" where there are other fields...
  2. A

    Add value of subtotal onto value of row

    Hello all, I'm unsure if this is something that can be done. However, I'm wondering if it's possible to add a subtotal (from a measure) onto a row value? In the attached example, I would be looking to add the Inbound actual excl recharges value, with the inbound unallocated actual value on the...
  3. N

    Count max no of consecutive positive/negative value in a filtered column

    Hello all, Excited for my first post. MrExcel has been extremely useful in my excel journey, even as a non member, and I couldn't be more thankful 🙂 My question: I have a column with positive and negative values in sheet "Sheet1" (image below). I would like to count the max number of...
  4. X

    averageifs in filtered table

    Hi, I am trying to calculate the average from a table using the averageifs function, because I only want to take into account the numbers between the lower and upper boundary (LB and UB). I know I need to use the subtotal function to not take into account the hidden cells. I could not find...
  5. S

    Power BI Custom Subtotals

    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...
  6. Wad Mabbit

    SUMPRODUCT & SUBTOTAL with same criteria ("S") across two non-contiguous columns [D3 Activity] & [D4 Activity] to return count of [Name] in either

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

    Pivot Table (from Database): count total of grouped items

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

    Subtotal above the pivot table

    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("*"...
  9. D

    Excel Formula Help

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

    Exclude year with sumproduct and subtotal

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

    Countif with filters

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

    subtotal with countif

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


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

    Positioning Subtotals to the next column on right

    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...
  15. muhammad susanto

    Average With Data Hidden NOT WORKING

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

    Subtotal a COUNTIF Range with an AutoFilter

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

    Finding empty cells in a column of a subtotaled range and pasting in a formula

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

    Subtotal in the last row of table

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

    VBA subtotal depending on indent

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

    VBA Subtotals one filter criteria from another column

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back