subtotaling

Hey everyone, I have a macro that contains a series of subtotaling based on criteria, and it seems to add the most time to the entire macro to execute. It is a decent set of data, 500-700 rows at a time, and subtotaling several things in succession. Is there a command to do it faster than the...

I have a report that is ran once a month and each sheet in the report has a variable number of rows each month. I have used the macro recorder to subtotal each sheet, but on sheets with more rows, the code does not include them in subtotal. I have tried using an offset but that didn't work...

Hi, I have a data set like below and need to create a subtotal of the sections. I cant use the sum if function as the table will be filtered and need the section subtotals to be dynamic in line with the table filter. The filters are setup for BRAND,REGION,AREA and SITE. The idea is I have a...

Hey all- I am attempting to "Sort" data based on the label/heading in the first row (i.e. Account, then by Type). <tbody> <tbody> Type Date Num Name Memo Account Debit Credit Balance Bill 0/16/2014 111111 John John company 10000 · A/R - xx 150.00 124,780.23 </tbody> </tbody>...

I have a sheet of data I need to subtotal. The issue is that the subtotal criteria is mixed in one column. Example: <TBODY> Column A Column B Column C Name 1 35.00 Shift Type 10.00 Shift Type 12.00 Shift Type 13.00 Name 2 20.00 Shift Type 10.00 Shift Type...

Hi everyone, Longtime listener first time caller. I have a couple of tasks that I am trying to complete for my boss. I am trying to rework some data and get some explanatory statistics out of it. My data set is a time series with 10 variables and about 5800 daily observations. First: I...

Hello all, and thank you in advance for any help given. I have 300 - 400 row sheets that I get every week that i need to separate chunks of rows (by dates), insert a blank row, and calculate the subtotal. Below is an example of what the information looks like before it is subtotaled Date...

Other than subtotaling NETAMT at change in Asset Nbr, how can I group by Asset No, and if NetAmt of group equals Zero, then move range to another WorkSheet. Example of WS is shown below. :confused: Thank you!

Hola amigos. necesito de su ayuda nuevamente. como puedo usar la formula de subtotales en columnas. es decir cuando pongo la formula en con referencia a un rango de filas al ocultar algunas filas me da el valor de las filas visibles, pero en columnas no puedo hacer eso. Existe alguna otra forma...

Hi All, I am trying to create macro for subtotaling rows: Application.CutCopyMode = False rw = Range(Range("A1"), Range("A1").EndxlDown)).Rows.Count col = 16 Range("A1").Resize(rw, col).Select Selection.subtotal GroupBy:=6, Function:=xlSum, TotalList:=Array(15, 16), _ Replace:=True...

I am having some issues with a conditional SUMIF statement. Here are the details. The statement below currently works. Contents of K14 =IF(J14="Yes",F14,IF(A14<>A13,SUMIF(A:A,A14,F:F),"")) Column A are Dates in chronological order Column F is a $ amount. Column J is "Yes" or blank. If Yes...

I am trying to create a subtotal in Column L for the values in Column K that all have the same date in Column A. All of the Dates in Column A are in chronological order. No dates are out of order. Example A1 = 11/2/2008 : K1 = 22.00 A2 = 11/2/2008 : K2 = 25.00 A3 = 11/4/2008 : K3 = 12.50 A4 =...