total column

  1. 4

    Cumulative sum with max

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Calibri; color: #000000}</style>I'm trying to calculate the cumulative total up to a certain maximum. In the example below, I need column D to calculate the contribution amount (by multiplying Column B and Column C), but...
  2. N

    Urgent - Help making totals add up after rounding to whole numbers

    Morning guys, I have a column of values containing 3050 rows. Each row has a value from 0 - 50. The majority of cells are 1's, 2's etc. I need to create two new columns to the left, one of which has 50% of the value, and the next having 30% of the value. The trouble is, I've done previous...
  3. L

    Getting a grand total from a sum of a column and one field?

    :warning:I have recently started my AS ICT coursework and I am having one problem with one of my queries. I need to create an invoice query to show the total amount spent by customers while they stay in a camping site (I will use this query to make a report). I have 5 tables, these including...
  4. P

    Sum a PowerPivot Column

    I'm near the finish line and am but a simple Grand Total away from declaring victory over a hairy PowerPivot Table with intense backend DAX. Problem is PowerPivot will not display a Grand Total on certain columns due to the nature of the DAX. I can live with showing a Grand Total in a cell...
  5. N

    How to show full totals in Pivot chart and table when you filter on one customer?

    Hi, I have a table with customers, months and totals. If I filter on one customer the total keeps changing just to that one customer. How would I filter on one customer but show the full totals? Thank you
  6. J

    tallying sales amounts

    Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have four columns B, D, E, G <o:p> </o:p> Column B = list of sales reps Column D = sales amount product 1 Column E = sales amount product 2 Column G = sales amount product 3 <o:p> </o:p> So, I have...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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