running sum

  1. H

    Excel Query about cumulative summation in the data table

    Hello, I have various rows with data 1,2,3,4,etc and various columns having ascending numbers from left to right. Like this -- removed inline image --- Now, at different sheet, if I give reference to the 3 and 20173, I want total of all the data mentioned in row 4 starting from 20171 till...
  2. T

    Running Conditional Sum Based on Month

    Hello all, I'm trying to structure a running conditional sum based on a monthly cash flow stream. To clarify, picture three elements: - A stream of twelve cash flows in one row, each one corresponding to a month - A list of twelve months in another row - A single cell that acts as a...
  3. J

    Trying to create a running total of invoices

    Hello, Message Board: I have a table with invoice details. I'm trying to create a query that will summarize the total $ of invoices by month. I created a field that will give me the month end date based off the invoice date field using the dateserial function (ie and invoice with a date of...
  4. T

    Advanced Run Sum Pivot

    I need to create a running sum in a pivot, which in itself is not hard to do as long as the running sum is only columnar or row based. What if the runnung sum is on both... let me explain... lets assume that the column headers in the pivot are dates grouped by month and year (Jan, Feb, Mar/...
  5. A

    Need Suggestions on How to Create a Customer Rollforward

    I have a customer database with the following: tblCustomers that includes the following fields: pkAccount_Num, Customer_Name, Service_Market, Acquisition_Date (required), Cancel_Date (null if customer has not cancelled). I have been able to summarize the data using 2 separate crosstab queries...
  6. N

    Question Re: Monthly Running Sum query

    Hello everything, This seems like a great forum and its my first time posting so Ill do my best to be as clear as possible... I have a table, lets call it "MyTable", it contains 3 fields: ID (Autonumber), LogDate (Date), Volume (currency) I need to create a query based on this table with two...

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