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

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