total amount

I have extracted some data from our employee database. It's 10,000+ rows. The first row of the employee is their name, a hypen, then their 9-digit SSN (11-digits including the two hyphens in the SSN). After each employee is 2-7 rows of deductions. The last row of the employee has the total...

I am looking for an automatic way to identify overlap and still count totals acurately. This might take a bit of explaining. In the table below, Columns A,B and C show values 1 through to 50 group in data sets. The first row, I am looking at lines 1 through to 10 which is a total of 10 lines...

Hi, I'm trying to do a 7 day rolling total in DAX, I've followed a similar structure to what I'd do in excel, in excel I wouldn't have the first condition, just greater than; < moving := VAR abc = MAX(Table1[Date])...

I don't believe that this particular question has been asked so if it has I apologize in advance. I am provided with a pdf of a transaction log from my client/landlord for each tenant that they are requesting Eviction proceedings for. It looks like this: Now I have to convert this to an...

So, i want to get totals using sumif but if i want to exclude a set of cells from totals based on criteria, how do i do that? Ive got the sumifs total, but i want to exclude "not ok" from the total. Most likely a combination of sumifs & if, but i cant get it. Please see table below <tbody>...

Hi All, Some fields are empty in the column, but I want to only count the fields with a date in this second tab. Tab 1 has the formula Tab 2 has the data in column C, the data being dates which I need to have the total number of cells which have a date in. So I'm thinking it'll be something...

So title says it all, I want to calculate this field: Even if I leave out some cells blank, it still calculates total:

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

HI All, Hoping you can help with this. I have a list of costs, which are attributed by date. What I want to do is calcuate a rolling total cost for the outstanding items, by month. I cant seem to attach an example, however, I have manually added the figures up for now by filtering the data, by...

A question came up on excel 2013 test to do the total amount of expenditure distributions (for each month) equal to 10% of the total cash sales (B1). i can't remember all the details;amounts, etc.. but it looked something like this: I am not sure which formula to use because I don't see how...