sum

Hey all, Thanks for taking the time to review my question. I must be missing something simple but for whatever reason I am missing something. In "Tab A" I have a list of "A" names, "B" dates and "C" total hours, In "Tab B" I have "A9:A39" each date of the selected month, "A1" the name I want to...

Hi, In the following formula I have type in the "A2:A6"; SUMIF(INDIRECT("'"&Sheets&"'!"&"A2:A6"),"a",INDIRECT("'"&Sheets&"'!"&"B2:B6")) Sheet = named range is there a way to have the reference to A2 to A6 in other cells so a cell A1 = "A1", A2 = "A6" and then just select those two...

Hi everyone, Is there an excel VBA code that allow you to replace part of a formula after cells selection ? For example, after selecting multiple cells, select the code to replace SUBTOTAL(9, with SUM( Some formulas examples: =SUBTOTAL(9,EA10:EA12) change to =SUM(EA10:EA12)...

Hello together, I have the following problem. I want the total weight of the tonnage per shift (Column shift - 1 or 2) and by date. The total weight should be added in each row of the 1st trip. As can be seen in the column "My incomplete result", I have succeeded for the 1st shift. The...

Hi there, I have a sheet where I want to sum up hours for a person per month. Tasks are entered on a row basis where the user enters the name in column C, hours per task for each month column H contains Jul, column H contains Aug, etc On a separate sheet I want to sum all the hours for...

A B 100 1 100 2 500 3 400 4 100 5 200 6 7 200 8 100 9 100 10 I want to sum a maximum of the bottom five rows that have values. I want to skip the blank rows. So the results of the formula in B10 should be 100+100+200+200+100 = 700 I will use this formula in an adjacent...

Hi all, Hope you can help me with the following issue. I want to calculate the average number of grounds in a selection of cities (E2:E4). In this example, the number of grounds per city are given in column C. However, I don't succeed in getting the correct number, because it takes into...

Hello, I have a dataset that contains pay period starting and ending dates as well as the shift. I am trying to figure out how to identify instances where an employee has worked a minimum of ten shifts within a 6 month period. The challenge seems to be in calculating a rolling total of sorts...

Please help in providing macro to concatenate and sum as below table. Below table starts from A2 to C9 (i'm leaving first row blank to write main header.) Customer Part Number Reference Designator Count 91814232 C339 1 91832745 MN28 1 91832745 MN7 1 91835171 MA2 1 91835171...

I want to SUM the numbers in a row which represent the worked hours in a month. The numbers in the cells have a leading string character like V8 or S8 or H7,2. How can I do that. See the mini sheet below for layout and desired results. Thank you very much...

Hi Experts, How to get result in Column L (Start) ? GIL1DataEndStart2315415161715891111011121213121415161111718191220122122132312413252627 For Column I ( End) , I use this code : Sub End2() Dim a As Variant, b As Variant Dim i As Long, k As Long a = Range("G2", Range("G" &...

I am trying to get dynamically the sum of Column E values if the corresponding F row value is empty. Any ideas what formula I should have on column G? Here is the live document link: https://1drv.ms/x/s!AkrCelEpjATAltgb8XshYXFVhjGaGA?e=VlNhyT

I need a formula that is using the data from the table named "Costs". I need to sum the Hours column IF the Concatenate column has any of these values...162FOL, 392FAL, 392FGL, 392FFL, 392PFL, or 452FGL AND the date is before 6/1/2023. This is what I currently have and it is returning a result...

Hi all, Hoping someone can help me with this query. I have a workbook I am working on that currently sums all the values in column "O" if the value on the same row in column "L" is "WP" or "BS" until an empty cell is reached. I would like to expand upon this formula so that it still sums like I...

Hi all, Hoping someone can help me with this. I'm guessing it super simple, but I can't find a solution anywhere online. Basically, what I'm trying to do is count the number of times each cell in a range (G4:G9) is not blank and is less than 70% of the value of the cell that is 2 columns...

Hello, I have two sheets, named: 1. Master Data - This sheet will be updated daily by pasting a system report over the existing data 2. 2022 - I want to calculate some stats from the master data sheet on this sheet The gist of this is, I need to report on people who leave between 0 and 5...

Hi everyone, I'm hoping you can help me with an excel formula to solve a problem I'm stuck on. I think I am pretty close to solution but just can't crack what it is I need to make the formula work how I would like. Basically, the problem is this: My formula is pasted all down column B. I need to...

Hi All I need to be able to create a formula to find out the number of units that are ordered on each day of the week. When a customer inputs a number into the day of the week column (MONDAY/TUESDAY) they are inputting the number of cases they want to order. I need this to then multiply by the...

New question for everyone, I'm trying to sum the prior month balance of all loan ID that are no longer in my current month as it was paid off. I can use this formula but adjust some values right? For some reason I get it to lookup all balances. =IF(Table2[@[Loan ID]]<>[@[Loan...

I am trying to figure out how to only look up ABC stock to calculate dividends only. Column B: indicates whether it is DIV, BUY, SELL Column C: name of stock (ABC stock) Column J: $ amount R3 = the lookup value aka stock How do I change this current formula to only include DIV for ABC stock...