subtotals

  1. A

    Disable subtotals (with a loop)

    </SPAN></SPAN></SPAN></SPAN><o:p>Hello all! =D I'm trying to create a vba code to automaticaly put all the fields and formats to my pivot tables to speed up my analysis. I'm having problems with the final part where I want to disable the subtotals... The full version of the code is at the end of...
  2. S

    Macro to Sub total varying lists of numbers

    Hi I am fairly new to excel and I am having trouble trying to get a sub total function to work for me. I need the subtotal to for a list of about 20 columns in one line with a varying amount of rows. So the subtotal must stop when there is a blank at the top. I can get the macro to find the...
  3. S

    Subtotals for pivot table with calcuations

    I believe this is not possible (as i am getting an error saying so) but does anyone have a workaround for getting monthly subtotals on a pivot table where there are calculated items? i've tried two ways: - highlighted date in the pivot and clicking field settings and then custom and then sum. i...
  4. A

    Correct Subtotals and Grandtotals

    I'm working on a pivot table where I want to move certain expenses from a department in one category to a department in another category. My pivot table is set-up with the "Category" and "Department" fields in Row Labels. My departments sum correctly in "Asset Retirements" based on the...
  5. F

    Subtotals - Show other data in subtotal line

    I often have spreadsheet with many columns on which sub-totals are calculated in 1 or 2 columns. Excel posts xxxTotal in the columns on which the sub-total is based. If you collapse the table to only show the subtotals, the rest of the fields are hidden. I would like to see all the data of the...
  6. E

    COUNTIF and VLookup Help

    Hello - I have designed a spreadsheet that seems to be a little cumbersome to gather data from. In the long and short of it, I'm trying to create a count for how many ads we posted, in which cities, during which quarters. Here is how the data is laid out: <tbody> Location Quarter - Website A...
  7. M

    Removal of subtotals from dataset

    Excel 2007 user. I have a spreadsheet with over 1000 lines of data, that is spearated into 30 different subtotal groups. I tried to eliminate the subtotal lines and revert back to the original dataset. I started clicking the small box in the upper left corner to select the entire dataset. Then...
  8. mrxlsx

    How to summarize data across sheets with dynamic & irregular ranges.

    Hello all, I have a query about summarizing data across sheets. I have my data in 12 sheets named by the month names and a Summary sheet. I have to summarize the data in the Summary sheet. The columns in all the sheets are Product, Qty for 4 regions, Sales for 4 regions, Commission for 4...
  9. T

    Macro to subtotal the hours associated with a name, then perform a calcunation on the subtotal

    I have a table that includes several columns of data. There is a column with employee names and another column with employee hours for each week the employee worked. Each record represents a week of work and therefore includes the emplyee's name and hours for that week. I want to subtotal the...
  10. H

    Counting fully filled rows in a filtered matrix

    Hi I'm trying to calculate the number of rows in a matrix that have a complete row of data. I would noprmally do this using nested if formuals and a count function, but the columns of the matrix are filterable so the count won't work. Is there a combination of functions that will adapt as I...
  11. X

    Using Conditional formatting with subtotals

    I am trying to work out a spreadsheet that I am using conditional formatting to highlight every two rows. I have 2 lines for each item and i need them to be grouped together. I can get the formula =mod(row(),4)<2 to do this, but then when i go to add the subtotals for each section it screws up...
  12. N

    Using conditions in the Subtotals function

    I've got circa 20k rows of data I'm analysing - it's activity with our clients over the last few years. I've used the Subtotals function to calculate Sums, Counts and Max values. But I'm stuck on two things. 1 - I want to show the last time we received a payment from a client - to do this I...
  13. azcat90

    Mode for summarized data

    I'lll throw this out to you guys... In Excel I am working with pasted output from an Access query that summarizes shipped packages by Service Type, pricing zone and rated weight. Goal is to find the mode weight for each service type. Currently I pivot the results and make the service type...
  14. G

    Subtotal Calculation

    Hello all, and thank you in advance for any help given. I have 300 - 400 row sheets that I get every week that i need to separate chunks of rows (by dates), insert a blank row, and calculate the subtotal. Below is an example of what the information looks like before it is subtotaled Date...
  15. J

    Subtotals and Weighted Averages

    I have a set of data that I ran Excel's embedded Subtotals function in the Data tab and used the Sum function in column "I" for each change in column "B". I am wanting to do a weighted average of column "L" based on column "I". I found this set of code in the forum that should take of this...
  16. I

    can I choose which pivotTable rows to subtotal?

    Do pivotFields have a property to let me not do any subtotal at all? For example, I have 'order by date' and 'item' as my rows, with 'amount' and 'deliver by date' as my values. I want to total amount, but totaling the dates doesn't make sense to me. I've been going with 'min of deliver by...
  17. C

    Pivot Subtotals that 0 out

    I have a pretty basic pivot table, but it is rather large. This pivot is by order number. What I would like to do is hide all order number rows if the net activity zero's out in the subtotal. Can it be hidden or quickly filtered? The subtotals should only show non 0 rows. So in the example...
  18. G

    Selecting Subtotals Rowls only

    Hello, I'm a newbie to VBA and I am having difficulty selecting only the subtotal rows after I've used the subtotal function in excel. I need to highlight the subtotal row a yellow. These subtotal rows are dynamic... Any help would be much appreciated.
  19. The_Rock

    Subtotal Any Column

    Hi Folks I was wondering if there was a way of making a formula dynamic/generic so that it would subtotal any column I want. The limitations would be that Row 1 always contains the header and that the result (subtotal) should be offset by 2 rows in the same column. So basically, if I have data...
  20. E

    Using Min Function in a Subtotaled Data Set

    I have a data set that has the Subtotals applied to the dollar column for every change in X. I have a date column as well. Imagine starting with the subtotals collapsed to level 2 so that the subtotals are viewed as a summary showing only lines with "X Total" with the underlying detail hidden...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top