subtotal

  1. 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...
  2. 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...
  3. 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...
  4. F

    Subtotal

    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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. tlc53

    VBA - Format Rows containing word 'Total'

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

    Insert row, update total formula to include new row

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

    Calculate Subtotals in Power Query Table

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

    Dynamic formula to calculate percentage

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

    Conditional Formatting & Subtotal Macro

    Hi All, I am trying to build a conditional formatting macro at the end of a string I already have that will help visualize the data represented. The data is located (A12:V750) but the conditional formatting will apply to Column F (I am hoping to have the highlighting apply to the whole row...
  17. S

    formula for grouping data

    i have a spreadsheet with multiple columns. One of these columns have a numeric value. I want excel to group the data based on a sum on this column. example: each line has 2 columns, one a name and one a value (which is a point). line 1 apples 5 line 2 pears 3 line 3 grapes 4 line 4 grapes 2...
  18. S

    Aging Report Formula?

    I was wondering if anyone knew if this was possible, I am trying to age a large file of accounts (5000+) that simply have user ID's attached to them, amounts and their date. What I am trying to do is to allocate each age appropriately. Meaning I would like to subtotal per User Id the fact that...
  19. M

    Average ifs for filtered data (visible data)

    Hi Everyone, This is my first post here! I am trying to play around with data on a trading strategy I have been working on. I have attached my problem into a new spreadsheet. The real original spreadsheet will be too large to attach here. What I need: I want to be able to filter data e.g...
  20. B

    Conditional Format Pivot Table

    I have column 'F' that right now has the number 1 if an event has been cancelled during the month. I was hoping to find a way to use conditional formatting to change the number 1 to the word 'Yes' if it was cancelled. I was somewhat successful until I noticed that the monthly subtotal would have...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top