total

Hi MrExcel, Hope you can help with the below, I've attempted to google but I'm struggling to find results. I'm trying to fill the total material used on the following two screenshots (there are about 40 total), the problem is if we require a SW 38x63 timber to be cut at for example 2m, the...

I have cost of $100.00, I need a 10% profit = $110.00. total selling price. I have a 35% lease agreement that reduces $110.00 to $71.50. I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same...

I have cost of $100.00, I need a 10% profit = $110.00. total selling price. I have a 35% lease agreement that reduces $110.00 to $71.50. I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same...

Hello, I'm quite awful at VBA and am trying to make a macro that does this: <tbody> E F G H I Item# Item Name Qty Total Tracking 1000 xxxx 2 xxxx 1000 xxxx 1 3 xxxx 2000 xxxx 1 1 xxxx </tbody> For this format, with the letters on top being default excel columns, I am trying to have...

Hi everyone, I am new to MrExcel.com - I have created a project portfolio spreadsheet to track the RAG (Red, Amber Green) Status of different projects. I would like to find the total number of R, A, G projects in a particular filter (i.e. Infrastructure or Publishing) so that everytime it's...

HelloI need to do no calculations in the Grand Total section when the results are the same in the Pivot Table. And calculate only when the results are different. As in the figure below: [/URL][/IMG]

Hi Everyone, I Have two ranges D20:D250 & F20:F250 I need a total these with this rule Not all cells have a value, Column D needs to be ignored if column F has an amount example <tbody> Column D Column F 5 6 34 43 12 17 66 12 12 15 6 35 4 44 4...

Hello, I have a tedious task of reviewing data in a piece of software. I only need two pieces of data in order to do my review, but there are a lot of data that show up. I only need the data shown below (data are fictional): <tbody> xxxxx08a.p 7.8.50...

Fellas, I have 365 daily reports that I have to go thru and change Total on every report and it will be time consuming which I need help please. My report is as follows: Column A:BC (55 lines) and I need to change only the flowing: I only need assistance able to copy and paste the values only...

Hello. I am trying to take the percentage based on plant and material number and segregate the handling units to two different plants. For example, in the information below, I want excel to look at another worksheet. if the plant and material match, plant 1 will get 20% of the total 5,801 and...

Hi! So sorry if a question like this has been posed before, I'm sure it will have been covered at some stage .. I'm looking to create a formula within a work spreadsheet as follows; If the value of a cell is lower than 5 then new cell is A, if it is between 5 and 9.9 then B, if it is between 10...

Fellas, I have 365 daily reports that I have to go thru and change Total on every report and it will be time consuming which I need help please. My report is as follows: Column A:BC (55 lines) and I need to change only the flowing: I only need assistance able to copy and paste the values only...

Hi there! I am trying to add the total points earned from a student. However, student ID column contains duplicate ID numbers. What I want to do is to create another column showing the student ID and the total points earned. Thank you StudId TOTAL POINTS 1619419 0.3 1619419 1 1619419 0.3...

I'm building a fairly complicated spreadsheet that is going to be updated weekly. The spreadsheets name changes monthly so building a macro wouldn't be user friendly and I'm trying to build formulas with the workbook. The user imports data from another spreadsheet into "Week1". From there...

Hi All, I have to extract some data's from large number of Dump data with multiple filtering.Which should to shown in summary sheet while updating the dump data for next frequency.Here below a sample data. Summary sheet : -------------------- July Aug Total Marks by 1...

For the pros… Been working on this for the last day…. I have a monthly report that update each week. It consists of cost center and account number. I want to control the budget and have the total of each account for each cost center. Not very complicated up to now… Here is the fun part: I have...

Please could someone advise me how to do this ... I am using an array formula which I found - however, I need it to sum upwards and not down The formula is =SUM(A1:INDEX(A1:A3000,MATCH(TRUE,(A1:A3000=""),0))) I need the total 682.20 to be on the green line, the total 191.20 on the next green...

Hi, I have the following dax formulas for my cumulative total and % cumulative. Its working but not showing the correct cumulative in the technical sense Total Items Delivered: TotalItemsDelivered:=CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER('DistProfile v1-3','DistProfile...

I have a fairly simple model that has 10 steps and the time & cost of each step. <colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="3" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody> ID Activity ActivityTime Activity Cost...

I have a pivot table with a list of different types of events in the first column (row labels), e.g. boiler repair, floor repair, window repair. The value columns are the days of the week, with the number of each type of event (repair jobs) occurring on each day. I would like to show the grand...