sum & index & match

I want to make this formula: =sum('MTD Data'!S11:U11) dynamic. =MATCH(A11,'MTD Data'!$B1:$B,0) returns the number 11, so instead of S11:U11 I want to take something like sum('MTD Data'!S(MATCH):U(MATCH)) that automatically returns S11:U11 What way is there do it?

Hello Experts, i need to plan my purchase requirements , we have a multilevel Bill of materials & few components are manufactured inhouse , few are from external vendors , our vendor base is also global.. few components are common for more than 1 finished goods.. some components are required to...

Hi! I have been working on implementing MRP Excel solution in a company I work for. I have already done one, and now I was working on a new more detailed system. My company prohibits me to install XLB2BB add-in so I will do my best to explain everything. First sheet 'ProdBOMs' contains Bill of...

Hello Experts. i have below data.. Date 01-01-2024 01-01-2024 01-01-2024 01-01-2024 01-01-2024 01-01-2024 03-01-2024 03-01-2024 05-01-2024 05-01-2024 06-01-2024 06-01-2024 07-01-2024 07-01-2024 08-01-2024 08-01-2024 09-01-2024 09-01-2024 10-01-2024 10-01-2024 11-01-2024 11-01-2024 12-01-2024...

Hello Experts, i have below data Part Num Date Issue Qty ABC 01-01-2024 7962 XYZ 02-01-2024 2938 ABC 03-01-2024 430 ABC 04-01-2024 1832 ABC 05-01-2024 9413 ABC 06-01-2024 9759 XYZ 07-01-2024 8676 XYZ 08-01-2024 147 XYZ 09-01-2024 5097 XYZ 10-01-2024 9240 XYZ 11-01-2024...

Hello - In excel, I have a column, E, with values. I'd like to find the sum of values from the last non blank row (summing upwards), where the sum is the closest to a predefined defined value, say 2,500. The values in row E, start at row 6, from the top. The column might also have blanks...

Hello, I am trying to figure out a formula to work out the cost of ingredients in different stores and then also look at the cost for the whole recipe at the same time. I have an example with really basic amounts in it just to give an idea. I have built it with a really basic =(A1 * I1) + (A2...

Hi I have data laid out as follows Record date Paid date Income 1 Income 2 Income 3 Investment 1 30/06/2022 12/07/2022 0 5 10 Subtotal 0 5 10 Investment 2 31/12/2021 12/01/2022 5 10 20 30/06/2022 12/07/2022 5 4 6 Subtotal 10 14 26 I'm trying to...

I am trying to do a summation of how many labs occur per week from a daily count on another sheet. However, I can not get the summation to shift down 7 days at a time. Is there a way to do this? Weekly summary: From the Daily Counts: I need It to sum a week at a time like this. Then , the...

Hi all, I'm trying to find a way of adding a total value based on the selection of two different cells. These two cells have a drop down list, each of the options on that drop down list has a value: The first image shows the drop list on the cells, and the second is a different sheet with...

Hi Guys, I have a huge excel table with 100+ columns and I'd like to summarize only the values from every third column. There is a solution for this? I summarized one by one but almost every day new columns are added and I have to extend the formula after each change. Thank you in advance! Gabor

I have a spreadsheet with multiple sheets that look exactly the same. I have found a way to sum all of them together but now I'm being asked to sum up only the tabs that the user selects. I am trying to figure it out and so far only have the following (see pic attached). I'm trying to update...

Need helping summing with vlookup or index/match. I am trying to add values that come up multiple times in the same column. Column A are the numbers that come up multiple times, and each has a value to the right of it in Column B. The bottom example is what I am trying to do. I just need a...

Hey Guys/Girls, I need some help with getting back the most profitable product in a single cell and a least profitable in another. I had a working formula but it didn't worked with empty spaces. I have a summary sheet and a second data sheet where i store all the information. On the summary...

Hi, Table 1 has many rows with costs in & in Table 2 I want to sum up these costs. Originally Table 1 did not have currencies in, so I was able to use the below INDEX MATCH formula to do this: =SUM(INDEX(2:6,N(IF(1,{1,2,3,2,5})),MATCH(C9,1:1,0))). Now I want to split the total of these 5...

I am working within Excel 2016 and I am currently using the following formula to count the number of dates equal to the week number. The formula uses indirect to obtain the sheet name in cell $J1 and counting the dates listed in column C. The formula works well but I am wondering if there is...

Looking at the below example, I'd like to be able to get the total hours of the individuals in column H by pulling their hours from Column E. Notice if there is more than one instance of someone's name, it only sums the first result. How might I be able to get the sum of a person's hours...

Hi, I want to sum a data table by year. How do I do that? 'Summary' tab - lookup Product A in the 'data' tab and sum the monthly expenses of Product A by year. https://docs.google.com/spreadsheets/d/1N76bSX4PbzdknOg3qbGBU2i5t6sD2Ld1LHJxzhD_SzM/edit?usp=sharing

Hello, I need a formula to count values from one column(Vendor) by the category of another. From there need to sum the value if the count is greater/equal to 2. EG.) Category......... Vendor......... Count(formula)........ Value.......... Sum(formula) Blue...

Hello. I am a bit new at using VBA for complex and detailed codes and I have really only used it for simple basic needs. I would say I have an average to above average understanding of it though. I am working on project in Excel where a User Form will open and display a Total Forecast Amount...