sumproduct

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

Hi there! I'm trying to figure out a way to sum a row based on two cells in the same row. I tried to use a sumproduct but I'm getting an error as I have text in my sum range. Any way to ignore the text to just sum the numbers? Maybe sumproduct isn't even the best way to go about this? I'm...

Hi everyone, I have a question that I've been trying to figure out and hoping the community might have some tips. For my individual stock portfolio, I'm trying to calculate a weighted average in cell D21 that excludes cell C6 and D6 from the weighted average calculation (SOFI). How can I do...

This hopefully comes through okay. I am looking to automate the information going into columns G and H. I highlighted the date ranges to make this a bit clearer. In the real world I will have "Source 2" with samples every 10 minutes. "Source 1" is just whenever a fault occurs. The goal is...

Hello, i have below data.. Customer Name Part No Sale Price Oct-23 (qty) Nov-23 (qty) Dec-23 (qty) ABC A 1.63 31200 15600 15600 ABC B 49.38 31200 15600 15600 ABC C 3.22 31200 15600 15600 XYZ A 1.63 9600 12000 0 XYZ B 49.38 9600 12000 0 XYZ C 3.22 9600 12000 0 SDF A 1.63 46800...