#sumproduct

Hi Everyone, I have a table that calculates the revenue and expenses per quarter of the selected fiscal years. For the selected fiscal year, its easy to get what the profit percentage is for the quarters. But I want to be able to calculate the profit percentage difference is for the selected...

I have a design sheet where I enter a quantity of fittings in the pipeline. In a second sheet there is a standard table containing design adjustment factors for a wide variety of fittings. To calculate what the equivalent straight pipe length would be for the various fittings in the pipe...

Hello everyone, I've been working on a stock analysis spreadsheet and am getting a little stuck trying to create a weighted score. In the spreadsheet linked below, I've got a couple of columns: - Answer (this is a "Y" or "N") - Score (if "Y," then 1; if "N," then 0) - Weight (either 1 or...

Hi, I have a problem combining a SUMIF and SUBTOTAL formula into one formula, so i only get the "shown" filtered rows summed when criteria is met. I hope you can help? =SUMIF($D$5:D25;”Small";E5:E25) =SUBTOTAL(9;E5:E25) $D$5:D25 - is the range to look for the word “Small” “Small” - is...

I found 2 very helpful formulas that work separately but I'm looking to find a way to combine them. I want to calculate the subtotal of D2:D101 only if the number is greater than 0 (so no negative amounts) and if the transaction type is "SALE" for G2:G101...

Hi, Im stuck with a formula can anyone help? I want to sum the bottom row in the image below when two criteria is met, which is 'A' and 'Qty' The problem is the sum range needs to be the bottom row only(figures). The criteria 1 (A,B,C) is a merged cell if that makes any difference! Any ideas...

Hi All, I work for a non profit organization and helping them setup a budget workbook and getting totals for . Any help would be appreciated. I'm trying to sum of the totals based on dates that have a criteria which is the Employee ID. My goal is to get a formula for the total of Employee #20012...

Hi Everyone, I have two sumproduct formulas that work on their own, but if I want to combine them both to get the total count for when both criteria are present, excel gives me the #value ! error. The formulas are: No1. Gives me correct result nr_FirstDate is a range of dates (not all cells...

In colume C & D I use the following formula to look into =INDIRECT(ADDRESS(SUMPRODUCT(($U$2:$AX$932=B5)*ROW($U$2:$AX$932)),(SUMPRODUCT(($U$2:$AX$932=B5)*COLUMN($U$2:$AX$932)))+1))...

Dear All, Thanks in advance for your time to help me with my inquiry. I have some expenses data where I want to select common or close text from a list and sum the amount spent for a specific month "Mar". Then I will work on creating a dashboard out of it. Example of output required...