sum

Is this possible with Excel formula (not Visual Basic). Extract first number in blue cells and divide by second number. Sum cells. Output would be sum(0.25/0.025, 0.5/0.1, 0.4/0.02) = 35. Number of cells is a variable.

Hi all, I need help creating different formula strings that can return a sum from text cells that contain multiple different numbers. Not the best way to collect data, I know, but until our org develops skills in Microsoft Access this is a direction we're trying (need to make it easy for many...

I am looking to see if this can be done as a formula but if it has to be VBA code then I can try and get it to work. Basically, This file will track the Ins ( Column E) and Outs (Column F) of Totes. The outs will go out every day but the ins will only be delivered if the route is scheduled for...

Hi all! Stucked with adjusting a code that sums my hours. I use two codes to get the value of the sum hours. The first one checks if both cBoxes are set, the second one is called after the check for making the sum of the hours. The looped list is on the second worksheet. The dates I'd like to...

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...