sumproduct

I have the following table with data CodeCategoryVx1/1/242/1/243/1/244/1/245/1/24...

'=sum of qty*value but only up to X qty I have a qty column and a value column and an trying to find the total value of a section of this based on a given requested qty

Hi Forum members, I have spreadsheet listing department members, the employment status and their team assignment. In another sheet, I have a table to summarise that data. When I updated the personnel list, several of the formulas broken and were not calculating correctly. Test_Summary sheet...

Looking for some help with a formula to calculate the total requirement of a part over multiple variants. Example below: Part list with Type Quantity Type1Type2Type3Type4Type5 Part101234 Part240123 Part334012 Part423401 Part512340 Type demand for each WK WK1WK2WK3WK4WK5...

I'm trying to do a sumifs or sumproduct with multiple criteria. I have lookups both vertically and horizontally and want the sum of the number that matches all criteria. If I needed no sum, I can do an index match, match, match, match. If I only had horizontals or verticals I can figure out...

I have to believe this has been solved before, but I could not find a previous post for my particular problem, so apologies if I missed a previous one. I'm trying to use SUMIF/SUMIFS or some variation of formula to look at two different columns of price amounts, determine for each row which of...

In one cell, I'm trying to get a product if from the array below. If I enter a date of 7/1/23, the result is the product of the Factor column for all dates that are less than or equal to the date entered. In the case of 7/1/23, the result would be 1*7*3 or 21. In the case of 1/1/24, it would...

In one cell, I'm trying to get a product if from the array below. If I enter a date of 7/1/23, the result is the product of the Factor column for all dates that are less than or equal to the date entered. In the case of 7/1/23, the result would be 1*7*3 or 21. In the case of 1/1/24, it would...

Hey guys! I would like to create a formula that counts the unique values in column G of the TB_incident_task tab with the formula below, which is my current formula. =SUMPRODUCT((TB_incident_task!$E$2:$E$8571=Dashboard!C14) * (TB_incident_task!$K$2:$K$8571=Dashboard!$B$5)) I tried to...

Sheet1 has a list of vehicles that are booked for maintenance as follows: Week NumberDateVehicleMaintenanceComments 4214/10/2024ABC1InspectionDrop off early 4215/10/2024ABC3ServiceNightshift 4401/11/2024XYZ20MOTAfternoon Sheet2 needs to draw the relative information from sheet1 for...

I have a table wher I'm trying to use Sumproduct by row, and an Fixed Range out of the Table Range. The Table Range is [B4:I5] and I need to use SumProduct on [H] Column that must consider the current Row and the Price Values, on Fixed Range, [C3:G3], to calculate the Total on Column [H]. The...

Hi, i am working with two tables. Table "Sum" looks like this. Priority 07/08/2024 08/08/2024 09/08/2024 10/08/2024 High 5 10 8 12 Medium 10 20 15 27 Low 30 15 27 13 none 50 81 38 67 The Table "Raw" looks like this Priority 07/08/2024 08/08/2024 09/08/2024 10/08/2024...

Hi, Greetings for all! I have a formula at Sheet2 as ...something(from this beautiful forum)..Sheet1!$A$2... When I insert 10 rows in Sheet1, formula in Sheet2 changes into ....Sheet1!$A$12.. How to prevent/fix formula to $A$2, how to fixate it to A2 Thank You in advance!! New Micro Excel...

Hi Excel experts! I loved my SUMPRODUCT for most of the time but am currently getting a mental block for this one, could anyone please help me tweak my formula (or even different formula suggestion for the below)? So basically, I wanted to summarise Total Sale figures by: (1) product type, (2)...

Hi, I'm trying to calculate the headcount & salary by allocation for a 5yr period where the salaries change every year, but the headcount allocation stays the same. I think im doing something very silly as the sumproduct formula that im using doesnt seem to work. Frmula used in F20 calculates...

Hi I am trying to do a sumproduct as a dynamic vba code but I cannot get it to work. I'd use XL2BB but i'm on a work computer so i can't install anything, so attaching picture for some clarity. This is for an order form and the reason i want it dynamic is because the number of rows changes...

Hello All, I have a formula that works as I want combining sumif and sumproduct. However, I am referencing another workbooks so I would like to use only sumproducts to make this happen. I have excel 2019 and don't have any power query functions...

Hello, I have used solver to optimize the sum of numbers given certain constraints, however I am now trying to optimize the product of numbers given certain constraints. When finding the optimal sum I can use a binary list to select the combination of item to sumproduct together to find the...

Hi I have reached the edge of my knowledge and need some assistance. I have a sheet that tracks crops and input chemicals, I need to summaries this into a table so that I can budget the cost based on the month the item is consumed. In Sheet 1. Data The first few columns are for the row...

Hi everyone, I'm using a formula that works perfectly but there is just one small issue. I need to do the sumproduct of positives and negatives values. SUMPRODUCT(--(1+MOD((COLUMN(M21:CD21)-COLUMN(M21));9)=1)*(M21:CD21<0)*N(+M21:CD21)) This one is only for negatives values. So if ever I...