totaling

  1. R

    How do you subtotal a sum?

    When I filter a table, I have this formula to tell me how many rows are being displayed as a result of the filtering: SUBTOTAL(102,PeriTable[ID]) I now need to do something similar for another column, but in this case I am totaling the numbers contained in these cells. As I filter the table...
  2. P

    Can I use same set of data more than once in Pivot Table-once to count, once to sum?

    I have lost time data in an excel file. I would like to use this twice in a Pivot Table-once as a sum, totaling the time and again as a count, totaling the number of events. Is there a way to do this?
  3. J

    Totaling Absolute Values

    Doing inventory, Item A is short -3 Item B is over +3 Total amount of inventory +/- is 0 but in reality I am off by 6 I know ABS returns the absolute value of a number and it is not a big deal to add an extra column for ABS Value But I was wondering if there was a neat trick to...
  4. S

    Totaling formula help

    Alright guys, I have a running log that averages numbers. For example I have =SUM(B10+C10+D10). That gives me my sum in E10. I also have a column in F10 which I DO NOT want included into that some, HOWEVER, occasionally that column gets an entry on it's own, producing a SUM of 0.000 in the D...

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
Back
Top