subtotal

Hi All, I am trying to build a conditional formatting macro at the end of a string I already have that will help visualize the data represented. The data is located (A12:V750) but the conditional formatting will apply to Column F (I am hoping to have the highlighting apply to the whole row...

i have a spreadsheet with multiple columns. One of these columns have a numeric value. I want excel to group the data based on a sum on this column. example: each line has 2 columns, one a name and one a value (which is a point). line 1 apples 5 line 2 pears 3 line 3 grapes 4 line 4 grapes 2...

I was wondering if anyone knew if this was possible, I am trying to age a large file of accounts (5000+) that simply have user ID's attached to them, amounts and their date. What I am trying to do is to allocate each age appropriately. Meaning I would like to subtotal per User Id the fact that...

Hi Everyone, This is my first post here! I am trying to play around with data on a trading strategy I have been working on. I have attached my problem into a new spreadsheet. The real original spreadsheet will be too large to attach here. What I need: I want to be able to filter data e.g...

I have column 'F' that right now has the number 1 if an event has been cancelled during the month. I was hoping to find a way to use conditional formatting to change the number 1 to the word 'Yes' if it was cancelled. I was somewhat successful until I noticed that the monthly subtotal would have...

I've used subtotal a lot and never has it failed me. However, now I am lost. Here's my data-set (simplified for example): <tbody> With Formula Flat Data Value 10.000 10.000 Value 10.000 10.000 Result 20.000 Value 10.000 10.000 Value 10.000 10.000 Value 10.000 10.000 Result...

Hello, Help is appreciated; I need to show a text column in a pivot table as the last column of the pivot table as it comprises notes on the information in the pivot. In my attempts, i managed to move the text by creating a calculated field 'measure' for the column turning it into a values...

Hello All, I have a pivot table into which I would like to total certain columns. The pivot table is structured as follows: <tbody> This is what my pivot table looks like 0000 0000 Total 0215 0215 Total 1001 1001 Total Grand Total OPCP CFP OPCP OPMA CFP...

Team, first time user here, I've spent days looking for a solution to this, but I think I'm close but I'm simply running out of time to turn this project in. I am looking for a VBA code that will allow me to auto-populate the first value on the first empty cell of column A & the last value on...

Hello everybody ! Have a good day Today i want to ask you how can i mix Subtotal & countif Because i want to count all the code in the table but it is Text , i used =COUNTIF(B3:B1858,"*") and it count all text but when i choose fillter some code. The number in countif cell does not change Here...

I would like to highlight column C with the text "Total" and "Grand Total" on multiple sheets using VBA. Can anyone assist? I have the VBA for a single sheet but can't seem to figure out how to go to the next sheet without debugging. Thank you in advance.

I need to use the SUBTOTAL function within a formula that uses SUMPRODUCT AND COUNTIF. The formula I'm using does a count of records in a list, eliminating duplicates. Now I need to use the SUBTOTAL function along with it to calculate the count of records, eliminating duplicates, when I filter...

I am trying to determine if there is a way to add multiple “IF”like functions to the troublesome issue of countif/averageif during a subtotal. For Instance, I retrieve my data from an internal server atwork that gives me a spreadsheet with times listed in column B, the type of...

I have a subtotal formula displaying 0 as the result when I subtotal a column below it even though the Formula Result in the function Argument Dialogue Box states the result to be $2,8792,942. My cell is formatted to accounting and I am using the exact same function and cell format in cell next...

Hi . I am wanting a formula that will count the number of consecutive sames values in a column that are together but not all of them in the column. I have 365 rows and i want to be able to insert the formula in B1 and drag down to B365 so that the Value in B wil update as and when A changes...

Hi there, I'm struggling to convert a SUMIFS formula into a formula that all totals depending on filtered rows. My original formula was: =SUMIFS(V$43:V$4678,$BV$43:$BV$4678,$A43,$K$43:$K$4678,"<>Programme") I've tried a fair few combinations SUMPRODUCT(SUBTOTAL(9,OFFSET but each time the...

Hello all! I am trying to get the total sum of a table, which has values in different currencies (ARS, CLP and UYU). I started studying DAX last week and I was able to get the correct sum per month, but the subtotals are not working. :( Basically... I have a table with the conversion of...

I am looking to combine SUMIFS and subtotal. I have tried to alter a sumproduct formula, but have not had any luck. I named my ranges to make the formula easier to write. Wsum equals the range I am trying to sum, WT & Sch are my two criteria. Here is a sumproduct formula that works to find 1...

I'm trying to Subtotal a series of SUMIFS functions. I currently have a series of the following SUMIFS function in column G: =IF(cur_month>=G$12-1,SUMIFS(amt_Jan,dpt_Jan,$A23,acct_Jan,$B23),SUM(G15:G22)) This pulls the values from another worksheet using named ranges. At the end of column G...

Hi I have a table like the one below. I sorted "Store" column. I want to find the subtotal of east store or subtotal of north store or north store etc. using subtotal() function. I know after sorting, I can go to Data tab-->subtotal, that is an option another option maybe I can use SumIf()...