total

I have a complicated windowed running total I'm trying to calculate. I've made an excel example that I'd like to implement in powerquery so I don' thave to copy the formulas down. Here's an example file https://file.io/k7yZ4D

I've seen a few of the forums in here with similar requests - how to take a column of data and where there's matches, total the sum of those cells. The consensus seems to be to use SUMIF instead, but I do think I need to use VLOOKUP. My goal is to analyze the data, and output a tallied set of...

Hi, I was wondering if this is even a possibility or if anyone has done something like this where they could help me. I receive spreadsheets from our clients (with two columns) the amounts they need us to withdraw from their bank account weekly. and there's a rounding issue. Example, even...

Hello, I am trying to sum a column based on matching PO#'s My sheet has the customer PO# in column A, the part # in column B, that part#'s total dollar amount in column C, and in column D is where I would like it to total that PO in the cell in that column. Below is how I have it set up and...

https://1drv.ms/x/s!AvjBsEPEq12ngTsi8XTPb5NMJ1_h?e=YIGtSL I wish to add the total for B and C in the Pivot Table like in cell D6. Suppose I update my PV and more data is added. How do I make it such that I can calculate the total for Company B and C and get $300? Hope that makes sense. Thanks :)

Hello, Ok so what I am trying to do is, I have a total of 500. And I have different accounts I want the 500 to come out of like for example: (A1) (B1) (C1) Dan. 100. ¤ Bob. 50. ¤ Mark. 50. ¤ John. 25. ¤ Alex. 200. ¤...

I'm summing total hours worked in cell J5, formatted as [h]:mm, to =sum(c5:I5) and getting 48:44. In cell K5. also formatted as [h]:mm, using formula =IF(J5>=40,40,J5) , I'm seeing 48:44 when I expect to see 40:00. In the next column, L5, formatted as [h]:mm using formula =(J5-K5), I would...

Please can someone help me with a script - I have a sheet that has a blank row every time a new name appears in column A What i would like is to: Place a total of the figures in column G - total in column F (last row) Repeat the headings from row 1 on each blank line Example of end result...

Hello. I am a bit new at using VBA for complex and detailed codes and I have really only used it for simple basic needs. I would say I have an average to above average understanding of it though. I am working on project in Excel where a User Form will open and display a Total Forecast Amount...

Hi please see the photo in the link; https://ibb.co/RPmLYTz Is it possible so that A16:A24 will display a product code and C16:C24 will show the total amount of each product?

<colgroup><col width="101" span="6" style="width:76pt"> </colgroup><tbody> POINTS BAGS WIN WE WE THEY TOTAL WE LOSS TOTAL 392 568 ($17.60) ($4.00) ($10.00) ($63.20) 551 427 $12.40 ($4.00) $10.00 $36.80 576 378 $19.80 $12.00...

Hello, I want to add second total row below grand total row. The row will display for each column the % of pivot grand total. How can I do it? Thank you

Hi, I am not sure if this is possible. I have an excel spreadsheet with lots of formulas - I call it my worksheet. To be presented to mgmnt, the content needs to be pasted as a numbers value only. This I know how to do. The "Total" rows (meaning subtotal and grandtotal rows) need to show the...

I want to match "Order IDs" and add the "sku items" for a total kit count. Thoughts? Thanks R. Turner

Hi. In my sheet I have data in a b c & d which can be a yes or no. Column E contains a name or email address. I want to create a 'league table' where if there's a 'no' in a, it's 1 point, b =2 points, c=1 point, d=1 point There are hundreds of rows and the names in E can be the same, I want...

Hi Everyone! I was looking for some help on creating a completion date forecast. Here are some details of my inquiry Total Callable Records: 60,000 Total Agents: 34 WorkHours/day: 8 hrs (weekends are not included) Start Date: 8/5/2019 I want to determine the date of completion with an...

Hi there, is there anyway that showing data "as a percent of' will relate to the entire dataset? Meaning, for example, that if I have a data-set of car models sales by car makers and I choose to filter 'Audi' in the pivot-table- The percent of sales for A3 model will be in relation to the...

I have a pivot table that is working out weighted average, now my issue is that the Grand total does tie back to the line by line version, any idea why? The Grand total is saying 78.56% but if I calculate it line by line its 78.14% what is causing the difference...

Hi, sorry I am stuck, your help is very much appreciated. I am struggling to think of how I can use VBA to check for a number in a cell (string - e.g. 8, 11, 18). Then I would like to tabulate the total numbers into a table of how many cells contained that number. Here is how the data looks...

Hello I want to make a simple table that counts "Yes" and "NA" as a positive and gives me a percentage total. For example if I had a list of 10 cells and I had 8 Yes, 1 NA and 1 No I want it to give me a result of 90% I have played around with formulas and can get this =COUNTIF(A4:A13...