sumproduct

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

I need to apply a minimum price to a sumproduct formula. If I multiply Qty x Price and the amount is less than £100 then a minimum price of £100 applies. I need this to be a solution with a sumproduct formula as I need to perform other calculations in the same cell with the result. Any help...

Dear users, I am trying to do the following but have been unsuccessful therefore I seek your help; I have vendors who buy TVs from certain Towns. The top left table displays the quantities of TVs bought by each vendor who has a record of purchase while the bottom left table displays the...