sumproduct

I have a lambda function which will not let itself be included in a SUMPRODUCT depending on the YEARS comparison. All other parts of the formula are working but stick the LAMBDA function result in there and it just won't have it... Why ??? Row 5 in blue are figures as a result of the lambda...

Hello Everyone, I have an Excel question. I have two sheets- tab a is the source data, tab b is data from a BI report. I need to match the IDs on both sheets, both in column A, and THEN sum all the matching values in the balances column to compare the report bal to the source bal. 1) the IDs on...

Hi everyone, Every month I get this table (Clients) where I am given costs broken out by rows of clients and columns of weeks. However, I need to summarize these values by Client and Month instead of week (Sheet2). Pivot tables don't seem to read across columns and my current sumproduct...

I am trying to perform a sumproduct with table references and when im trying to add a extra condition it will no longer work. Below are the two examples there must be something simple I am missing the @Type field is just matching text, if anyone could please guide me with the correct syntax to...

The lower table refers to the upper table. The upper table is somewhat successfully dynamic (side note: if I could use: =SUMIFS($G$4#,$M$4#,$O4#,$K$4#,Q$3#) instead of: =SUMIFS($G$4:$G$1000,$M$4:$M$1000,$O4#,$K$4:$K$1000,Q$3#) that would be cool) Is there any way to modify my formulas in the...

A certain company has taken a loan in installments. Depending on the number of years that have passed since the installment was taken, the company has to pay a certain multiple on it. The loan installment that was taken first also gets paid out first. It is possible to make partial repayments...

Hi! I'm trying to have excel return a date overlap. The criteria I have for this are, If the name (Column A) is the same, RA (Column B) is different, the end date (Column D) is not the same, and there's overlap then flag this row down. So for example, Row 13 and row 7 should be flagged down...

Version: Excel Online I want an average of the time (in days) between two milestones for many different people (one person per row), but I want the formula to ignore that row if there isn't a date in BOTH date cells, since it throws off the average in a major way. Example "TABLE_1" EE Name...

Hello people! I am quite new to proper work in excel and I need some help! I have this table with sales and revenues from the months december 2014 and january 2015, the sales and revenues are made in 5 currencys, FX rates are given in another sheet . I need to calculate everything in euros...

I've got data organised in the following way: 2 first columns are identifiers and the rest of the columns are values by year (a year per column). So I need to summarise it in a different table based on 2 identifiers an by year. So each value in the summary table should match the combination of...

Hello all, I am having a problem, I thought I got it all figured out with sumproduct function. However, it doesn't work as it should. I am trying to count all the cells containg "2" in columns AM:AO, but only if "1" is found in columns AJ:AL. Ideally a formula that can be further filtered, for...

Hi All, I'm not sure if this needs a Countif formula, a Sumproduct formula or something else. I have the following sheet and I'm tying to do a count based on multiple criteria I need to count based on the following Criteria in the Sheet "Trg Register" COUNTING CRITERIA In sheet "Trg...

I am trying to create a formula that looks at results and levels and then calculates the sum of points. ACADAEAFAGAH34CompletedDoingProposed5144 Credit Points258006100max 60 @ 100 level7200min 36 @ 300 level8400max 12 @ 400...

So after many hours and lots of assistance I am nearly there. What I would like now is the following, this is my current formula: =SUMIFS(Group1!$N$3:$N,Group1!$D$3:$D,"<="&$B$14) I would like to add to this formula is 3 more criteria. That formula is in H14 and I would like to add H13...

I have a formula in a column S that looks like this =-IF(N83="Feed",O83*$E$33*$I$62*(P83/$I$60+$I$61),0)+R83 Column n = who transports Column o = Pickups Column P = round trip distance Column R = Cost Column D = Start Date Cell E33 = Weeks in month Cell i62 = rate - want to make this...

I have a data set with unique IDs in column B and dates in row 2. I am trying to make a formula that looks at a date I've selected, finds that column in the data sheet, looks at at a range that includes the found column and the 11 before it (i.e., a whole year), then counts the number of rows...

Hello Can someone please help re-write the formula. Not sure what I'm doing wrong, I get #REF error. =SUMPRODUCT(INDIRECT("'"&C$1&"'!$c$5:$au$54")*(INDIRECT("'"&C$1&"'!$a$5:$a$47"=E2)*(INDIRECT("'"&C$1&"'!$c$1:$au$1"=E2)*(INDIRECT("'"&C$1&"'!$c$3:$au$3"="total")))) C$1 = Worksheet reference...

Hello excel experts, I have the following formula: =SUMPRODUCT(SUBTOTAL(103,OFFSET($F$26,ROW($F$26:$F$999999)-ROW($F$26),0)),($A$26:$A$999999=$A21)*($B$26:$B$999999=$B$7)) The issue that I have run into is that each time I update my pivot table that uses this formula I run out of resources. I...

Hi all. I got a sum if function, that looks like this: =SUMIF('(PATH)'!$F:$F;">"&(EOMONTH(TODAY(); -1)+1);'(PATH)'!$H:$H)/1000 But it generates an error, because of the closed workbook. Can somebody help me create a SUMPRODUCT or SUM(IF - function?

Hey all, I am trying to create a formula in the that only sums the first unique value in column B but I need this sum to include a secondary grouping criteria which is column A (so only sum unique values for the Apple ground and then only sum unique values for orange and so on). I am not quite...