sum

List 1 has item numbers, and I want to return total sales dollars. List 2 has the item numbers across multiple locations, and I want to return the total sales dollars into column B on List 1. What formula do I need to put in B2 to return the total sum? (B2 Value should return $315, B3=$230...

Hi, I have asked this question on MS website ; Redirecting If I have a an array from indirect ; INDIRECT({"Sheet1","Sheet2","Sheet3"}&"!"&"A1",TRUE) , which returns a spill of "#VALUES" but if F9'd will show ; = {2,3,4} , which is...

Hello Using the basic salary column on FY 22-23 as an example, I need a formula to sum this column into basic salary on the stats sheet, if possible using the sheet name in column A as a reference to the sheet to sum from. All columns across all FY sheets are set out the same. Stats sheet...

Hello all! I am trying to sum each row in a spilled range. I imagine I would have to use the MMULT function, but I can't figure it out. I kinda know how to sum each column so I've just tried to modify it to sum the rows instead but now luck. =MMULT($I$9#,SEQUENCE(COLUMNS($I$9),,,0)) Thanks...

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