I am using VBA to get the data from a larger worksheet.
Is there a way to get 2 subtotals in the sheet with only the 8 columns.
I have grouped this data by date (column 1) and used SUM on Column 8 to get the subtotals of each group.
I would also like to get the COUNT of the items of each groups by using Column 3 (it has alphanumeric data in it) - at the same time. Is this possible?
If not, how would I be able to get the COUNT without wiping out the SUM subtotals? This has to be done with VBA of course.
Is it possible to use the worksheet function Vlookup on subtotal values? If so what is the formula? The problem that I am trying to solve is as follows. I have a sheet (1) listing part numbers that are not moving at a particular depot. On another sheet (2) there are details of sales relating to the non-moving part numbers at 6 other depots, I have added subtotals. Currently I am switching between worksheets to see if I can transfer stock. I would like to id on sheet 1 the total number of sales at other depots, then I can see what part numbers may be transferrable without a great deal of manual intervention.
I have a workbook with two tabs, Summary & January. The january tab has total expenses for the month of january that are subtotaled by last name. i.e. (baker total, decker total..). I would like to be able to use a formula on the summary tab to pull the values of each of the totals for each person from the january tab to the summary tab.
I tried on the summary sheet doing =jan and selecting the first persons name and then going back to the summary tab and dragging that formula down but it pulls all of the other data within the subtotal on the jan tab and I just want each persons total.
way to do this but i have a sheet that is into 5 - 6 thous rows, in one of the columns (names) i sort it by names and then order it by subtotal for certain values.
What i need to know, is there anyway i can take just the subtotal values out and put onto another spreadsheet without copying and pasting it all as there are lots of subtotals and this would help alot as the other info is not nec. just the subtotal'd info. either that or is there anyway i can highlight the subtotal'd row info in yellow/bold text anything like that that would make it stand out without having to do it manually?
I’m trying to get my sheet so that at each change in month it creates a sum of the value but I want to sum to show up in the subtotal value column.....
I seem to be experiencing a problem using the SUBTOTAL formula. Is it not possible to use subtotal in a running command? ie [A2] = SUBTOTAL(102,A$1:A1) then drag for a couple cells vertically. "0" is displayed for ALL dragged cells.
I am subtotalling a range of data and the very last subtotal row appears about 70 rows away from the other data and then has the GrandTotal underneath.
I tried "googling" this, but I can't seem to find an answer. Is there a way in VBA to refer to the "subtotal" row(s) in a sheet? I have a large sheet that has a varied number of rows. Each month the data changes and I have to go in to the report, subtotal by one column and then enter a specific formula into the subtotal row.
Is there a way to reference the subtotal row in VBA so I can write a macro that will do this all for me? There are typically a varied number of subtotal rows and the locations of them change depending on the amount of data we have each month.
I have a spreadsheet that has columns for "Invoice Number," "Order Number," "Invoice Date" (DD/MM/YYYY), & "Amount." It is formatted using a macro.
I need macro code that will group all invoices by month and subtotal each month, then put a grand total at the bottom. Also a blank row needs to seperate each month.
What i would like to be able to do is subtotal all the sheets (Approx 190 Sheets) with subtotals in Column I and (K to AA) with each change in Column D Period reference D3 till the bottom the data is entered. As an example i have attached a sample with one sheet 77001 showing what result i would like.
I have added subtotals to a worksheet, as I have many times before, but this time I don't see any controls off to the left. I am at a loss as to why this might be happening or how to get them to display. Have I toggled something off or on that might be causing this?
I a formula in one of my cells so that when the data is filtered it will add up all the cells that have a yes in them. However I'm getting an error. If I use the countif formula it still adds all the cells with yes that are not in the filter selection.
1) I have an a list of transactions (multiple lines per day / per item - variable count of lines) that add up to form daily profit.
2) I want a count of the profitable days (i.e. where the sum of (1) above is +ve) and conversely a count of losing days (i.e. where the sum of (1) above is -ve)
3) My existing SUMPRODUCT formula "=SUMPRODUCT(((InputAcctDest=$A8)*((LEFT(InputCalc,3)="ALL")+(LEFT(InputCalc,3)="TRD"))*(MID(InputCalc,21,15)>0)))" simply produces a count of the positive numbers, not a count of the subtotal per day when such total is positive.
I have a large spreadsheet with production numbers on it. The sheet shows the day and time that each run starts and the day and time that each run ends. It also shows the usage of a raw material that each run consumes. What i need to do is figure out how the usage per day not usage per run. Until now i have been doing it manually and with all the data i have, it has taken 4-5 hours each time we need to update our usage. If it makes it any easier, the hours can be rounded - so long as the usage stays the same. (ie. if a run starts 5 min before midnight, we can assume it starts at midnight as long as the usage is not reduced fro the run). I have attached a sample of the data so you can see what i am working with.
Having n issue explaining a statement to a customer. I want to list his incoming payments and invoices in an Excel sheet. So going in order of the statement I'll list the in and outs but I would like a subtotal under each transaction so he can follow easier. Example
Is this possible using the subtotal command? Here is what I'm getting $68,920.77 $68,920.77 Total $68,920.77 $13,812.43 $13,812.43 Total $13,812.43 $12,563.14 $12,563.14 Total $12,563.14 $(20,000.00) $(20,000.00) Total $(20,000.00)
I have a report with sales YTD. I need to split it by weeks (incremental YTD) so I can use the subtotals to create a graph showing how we’re getting close to our goal for the year. To be clearer, what I mean by incremental is creating a YTD by week column like shown below.
I have an excel workbook which contains two sheets. Sheet 1 contains a list of items. I need to search for each of these items in sheet 2 and sum up the 'base price' and enter into column B of sheet 1. So basically
1. I need to pick up the first item in sheet 1. 2. Find the column which contains "Module Name" in sheet 2. 3. Search for the item picked up from sheet 1 in the column which contains "Module Name" in sheet 2. 4. Sum up the "Base Price" for all occurrences and enter this summed value into column B of sheet 1 next to each item.
I'm running the subtotal function, but for some reason Excel is including first row of next group in one of the groups. The label I am subtotalling on is the result of a formula, but why would that make a difference?
See row 11 and 12 in the attachment : subtotal problem.xlsm‎
I am using the SUBTOTAL function, with reference value 4 to return the max value from a filtered list.
What I'd like to be able to do is return the values of cells on the same row of the returned max value. Effectively if I can extract, somehow, the row number of the row where the max value exists, then I can use that to get the rest, but I'm at a loss as to how to do this,
I have a 3 layered table: all of the data, the subtotals, and then the grand totals (the subtotals added up). I did the subtotal funcation for all of the subtotals and for the grandtotal. The grand totals grabs all of the subtotals accept for one row. All of the 4 totals miss the one subtotal row. I looked at the formula and it is correct and the same as the rest of the subtotals in the table. This row is in the middle of the table and I did check it is included in the reference in the forumla. I do not know how to fix this, or if it is an error?
I have a spreadsheet where users will filter it using autofilter. I then have two cells where the val/volume of each account is totalled, this works fine. However I would also like to be able to say which is the most recurring product within the account and how many times it occurs. I have attached my sheet below, I hope this helps. Eg, Account 1 worst product is..... with a volume of...
I have a sheet with about 3000 lines that looks something like this:
A...............B..................C 1234........$42.................Subtotal of all values in group "1234" 1839........$58.................Subtotal of all values in group "1839" 1837........$15.................etc 1234........$11.................etc 1592........$19.................etc
The numbers in column A refer to a specific "group" number - anything in this group I want to subtotal into column C.
I'm not sure how to do this though. I've looked at the =SUBTOTAL function, but I'm not sure exactly what to do to make what I'm trying to do work.
I wrote a For Each loop to go through each cell and add values, but that took like 4 hours to run - so.. that's not the way to go lol.
