running total

Hi all, First time poster. I'm a novice when it comes to excel, so please forgive my amateur knowledge on excel :)... I have an excel sheet that shows deliveries in and out. I would like to create a new column that would have a running total/inventory. <tbody> Units In/Out Total on Hand...

I'm trying to calculate a running total of ticket sales with 5 different groups (adult, youth, senior day, senior night, and child) to where once the number of tickets are bought it will update automatically. I enter the tickets in cells B5-B9 where it then calculates the amount due and the...

Hi, I'm using Excel 2010, I have a personnel tracking sheet that tracks an entire year for each employee by day and pay period. If a person calls out sick the cell is coded with SCK or sck and the hours that they are out ex: SCK 8 or sck 10.5 or SCK3.5...(some supervisors put a space after...

My desired result is the green colored column. Running total as it were. If I take out the Document Forecast Type and Document number columns, I can use the natural running total option for the Combination Qty field as follows: I figured there should be someway to use DAX to achieve the...

Hi All, I've been banging my head against this on-and-off for a week without success. Sould be simple: Select a field (This case Delta), then show values as a running total against the basefield Date. Works fine until I group the Dates into Months and Years as shown below: As you can see...

OK! So the issue of the day IS... I want to make cell (E4) return a number (1 through 20) based on a series or ranges which are entered in cell E9. The ranges are... 1 to 99 = 1, 100 to 224 = 2, 225 to 274 = 3, 375 to 549 = 4, 550 to 749 = 5, 750 to 974 = 6, 975 to 1224 = 7, 1225 to 1499 =...

If I have a list of values say 1 2 5 4 2 3 is it possible when graphing for my line graph to show a running total? so the points on my graph would go from 1 to 3 to 8 to 12 to 14 to 17. I'd like to do this with a formula instead of creating an extra list next to it of running totals, then...

Hi, I'm really new to excel (2007). But i've managed to create a worksheet that tracks payments for me and my coworkers. I made it such that it tracks the outcome of post-dated payments as well. i used one of the conditional formatting options (3 symbols circled)... so if there's a payment...

First of all thank you in advance for reading this and providing any and all help to this newbie. I am using Excel 2010 and am working on a commission tracking sheet for my company. What I am having trouble with is this: we have a tiered pay out system, that increases every 25 points you get...

I created a pivot chart with a running total. In the first example below [sorry, IT doesn't allow me to use the HTML maker], the running total of the for that category works fine (Amount, Show data as: running total in, base field: Date). FYI, the fields Category, Date, & Amount are in the...

My table contains data of multiple vehicles ordered by vehicle registration number and then their date-wise statuses (such as ignition on, ignition off, driving etc.) I have an odometer column which tells me the distance covered between the last status and the current status. I need to insert a...

Hello, I am trying to keep an excel sheet for a formulary at a volunteer clinic for the medications we carry. Part of it will include couple of columns to have the current on hand quantity. I would like one column to have the total on hand quantity, and another column right next to it to have...

I know I'm going to feel really dumb about this when I find the answer - but here goes. Problem: I've got a database that consists all of my stock transactions for the last 20 years. The fields include: date, account, stock, activity, number of shares and cost per share. I've used a Pivot...

Is there a way to have a footer so when I print it will tell me the totals for: a) the sum of the data per column of the current page b) the totals of the data per column of the pages prior to the current one c) the sum of the previous 2 cells

I'm fairly good with Excel, but this one has me stumped. I have two spreadsheets with data for records which are found in in column A. There is not necessarily a record in sheet2 for every record in sheet1. The columns of the two sheets represent dates and those columns and dates are the...

I have a pivot table with all my accouts transactions. I am trying create a month by month balance sheet. I can get the running total to work month 1 (ie March 2011) onwards but I need it to pick up the opening balance which sits at >01/03/2011. Can anybody help?

It really isn't running that far, but I need help with figuring a running average for the last 30 days, 3 months, 6 months, and year from today's date. I have been trying to use an averageif function, but it doesn't quite work the way I want it to. I have a due date and a delivered date which...

I am trying to prepare a report that provides a running bank balance for a large amount of bank account data. I only need 2 fields [Date] and [Net Amount] to make this work (or so I think) I of course am using a pivot table for this and I am trying to get it in this format: 2006 2008...

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

I am trying to create a basic spreadsheet in MSExcel used to collect standard info (Name, address blah blah blah). The people who will complete this will need to classify the people they are listing into groups (Group A, Group B etc. 5 groups total) and each group will be listed on a separate...