sub total

  1. P

    DSUM() with multi-criteria in single field

    Hi! I have the following DSUM() code with multi-criteria, BUT I need to adjust it so that I can 1) filter for more than one criteria on [Shift Info] and 2) so that the criteria for [FR_Date] range works? For Example: And [Shift Info] = 'Day' And [Shift Info] = 'Night' And [Shift Info] =...
  2. C

    Sub Total, Filter

    I have problems what to filter first before executing a Sub Total: I have 6 columns: I want to have a subtotal per Customer per Brand showing the highest amount of per Customer Like : Gas Total 1,450,000 Diesel Total...
  3. D

    Code for Sub-Total command with rows changing in Macro

    Dear Sir, I am trying to have a code (to be written for macro) for performing Sub-Totals in the column I excel sheet as a part of automation. The rows will be dynamic and No. of rows for each sub-total changes every time. The sub-total shall be based on certain criteria which will be in other...
  4. T

    Inventory Aging by Purchased volume and inventory on hand.

    I have seen some similar threads on this, but most deal with dates, not volumes. I am trying to write a formulate that will track volumes purchases, and by comparing to on hand volume, show me unsold inventory. Example A B C D E F G H I J K...
  5. M

    Subtotals with Pivot Tables

    With Excel 2003 is it possible to stop a pivot table from automatically adding in subtotals. Thanks
  6. B

    Highlighting alternate subtotals and the preceding values

    Hi there, I am using subtotals on a daily basis to get batch totals of money that a supplier has banked on our behalf. For clarity, I want to highlight every alternate subtotal and its preceding rows so that when printed each group of values that make up a subtotal and the subtotal line itself...
  7. A

    Progressive Sub Totals

    The following is a simplified version of a spreadsheet using Microsoft query to populate columns A and B. I need a formula that can be copied down column C that will recognise if the row is a Sub Total and apply the relevant total using the rules below: <?xml:namespace prefix = o ns =...

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 MrExcel.com.
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 "mrexcel.com".
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
Top