total

I have a pivot table that is showing sales for some rows as well as the % of total sales for those same rows. I do this for this year and last year time frames. I want to be able to have a calculated field that show what the point difference is between a row's this year percent of total...

I have a folder I’m importing monthly files from. I will have the main table be my “2019 Total Sales Data” table. However, I’m wanting to break that same data out by month (Jan, Feb, Mar.... tabs at the bottom). I know that I could just duplicate the main query 12 times (giving me 13 total...

I want to look at a filtered list and see how many items in col A are a Yes or a No. I know to look at the total items in the filtered list I'd write =subtotal(2,A1:A100). But how do I separate the two values?

I've run a pivot table like I normally do. Is there a way to find out what percentage of total values each bucket is taking up? In the data below the total is 30 rows of information. So in C1 I'd like to see whatever percentage 5/30 is, in C2 I'd like to see 33% (10/30). Is there a way to...

Hello all, I need to create a summerised parts list from a Bill of Material, ensuring that all items are properly accounted for as the BOM is multi-leveled. A sample of the data: - <tbody> Item Level Part Number REV Qty Per Qty Total 0 0 HD IBC 7500 F50T 2 2 1 1 FHF57 AM132/M 01 1 2 2...

Is there a way to divide a running total by another running total in a pivot table?

Hello, I'm working on trying to auto-fill a sales table I have by inserting either formulas into certain cells or creating a VBA macro. I'm comfortable working with both so either method to solve this problem would be great. I've recreated the table below since I didn't see a way to attach my...

Hi I have the below data and need to be able to show the total for certain dates in each month, for example for February I want to show the first 15 days total while still showing the full total for january. I have tried to insert slicer with day in it but once I select the first 15 days it...

hi, how can I add a year today total at the end of list each of the box in the code below represent amount per moth (January-December) here is the code: COGSform_All.TextBox_Results1.Value = .Cells(.Range(strAddress).Row, 2).Value COGSform_All.TextBox_Results2.Value =...

Hello I am so glad to find this forum, might question might be super easy for most of you but I am beating my head on a wall from last few hours so thought to register and raise it here I want to Select the month in month total say March it gives me No. 3 and in YTD total is I select Mar 16...

I am working on a scorecard and for a portfolio section of it I want to either calculate or lookup the most recent dollar amount of total open loans of the officer in cell C7. The table below (Located in a separate sheet) is named "Port". The expected result is $52,000,000 (Adam, most recent...

Someone please solve this equation. I have a markup equation that I fill down. I'm trying to net no less that 5.00 but I have products with a wide range of total cost. Price = Total cost + Markup percentage. Net = Price - Total cost. That part works great. The following is what i'm trying...

Hello, Below is the simple data sales vs safety stock. I need 1 formula which calculates total number of sales more than safety stock. In this case it is 2 <tbody> sales1 safety stock 1 56 2 5 3 1 4 9 5 1 Total numbers sales more than safety...

Hi All, Could someone please help me with the query below I have 3 sheets Labels, Labels and Categories and Results. I have to check the all the values in Labels sheet against Labels and Categories sheet and report the total numbers in Result sheet. Please see example below. Thanks in...

here is a snip it of code for totalling time numbers of items pulled from a listbox into an array, then another array holding data is search for a match then the time number pulled from dataarraylist postion 3 column. msgbox total should show say 0:33 BUT shows...

Hi guys, Just a quick question on how to get a predicted Clock Out time for the week with 60.5 hours MAX. Column1 is the total so far in the week. Clock In Time is Todays clock in time. If the Recommended Clock out time is 12 hours or more away, have it display a text. <tbody> <tbody>...

Good Afternoon, I am trying to edit the row subtotals and grand totals in a pivot table to include items that have been hidden by the filter. Here is my data: The data table is top left, pivot top right (with filter applied to remove 0's from B) and bottom left is a snip of the pivot...

Please help! I am struggling so bad! I am trying to run 4 potential values. C11 can contain "Mini" or "Regular" Mini = 5.50 Regular = 6.50 BUT If H11 contains "Lays","BBQ","Doritos", then add .50 to total. So if they select one of those options, the total then becomes 6.00 for a Mini &...

Hi, I have sales by the hour. Each hour I have a cell with the total sales. I'm looking for the best way to have running total, but if the time is after now it will display 0. 1pm $200 $200 2pm $150 $350 3pm $ 75 $425 But if the time is after now then dont give the hourly...

Hi I have been periodically creating a stacked column chart. This now has been divided in 3 sections and so the chart has to follow! I'm sure this should be really simple but I just cant seem to manage it. I eventually got it split into 3 by transposing the data but now I am missing P6 from my...