sumproduct #value error

Hello everyone! I had this issue in excel on my laptop only and not on PC. I have created a table which is the Master of my workbook. I have used sumproduct, filters, unique function and it was all worked nicely on my PC. But for a sudden when i have move this sheet to my laptop all of the data...

To set the scene, I have an order report that has every order placed on the ordering system for every project ever. I want to add up the sum of the 'quantity ordered' and the 'price per unit' for a specific item and a specific site. Therefore, I need to only add the sum of 'quantity ordered' and...

Hello community. I'm sending attached the file that's an adaptation of a free template that i found online. During my adaptations i came across with a problem that i can't solve: In the attachment you're allowed to see the formulas apllied to "NJ" and "NK" cells, where in the formula bar the...

I'm trying to convert a model that has a complex sumproduct formula: "=SUMPRODUCT($AX14:CB14,N(OFFSET($BX$4:DB$4,0,COLUMN(DB$4)-COLUMN($BX$4:DB$4))))" And once the column count gets to 31 (range of AX->CB...BX->DB), I get the following error: "SUMPRODUCT has mismatched range sizes. Expected...

Please can someone help me with this formula issue - =SUMPRODUCT((Table2[Department]=[@Department])*(Months=[@Month])*(Table2[[Month 1]:[Month 12]])) Notes - 1) The Second Array is the Month dates which are outside and above data table 2. 2) The Third array is the 36 cells of data. 3) The...

I have a column (A) with dates formatted this way "Tuesday, September 04, 2018". I also have a column (B) with corresponding amounts in it. I am trying to use Sumproduct to add all the amounts in column B by month using this formula =SUMPRODUCT((MONTH($A$3:$A$3238)=$C3210)*($B$3:$B$3238))...

Typing =SUMPRODUCT({0.5,1,0.5},{4,3,2}) into a cell gives a result of 6. I’m trying to get the same result by putting {0.5,1,0.5} in cell A1, {4,3,2} in cell A2, and =SUMPRODUCT(A1,A2) in cell A3, but when I try this I get the #VALUE error in A3. Is there a way to carry out this SUMPRODUCT...

Hi Everyone, I have two workbook, one is data sheet and another one is report sheet. I am trying to pull out the values from my data sheet workbook to my report sheet wokbook. I tried both sumifs and sumproduct, but both formula work once the source file gets opened. I need a formula which...

Can anyone please help me figure out a formula to calculate YTD?? What I am trying to achieve: Sum all months <= current month, ONLY IF months fall within the same year CY (Calendar Year) as the current month As you can see on the screenshot below, Cell B5 indicates the current month. The...

This formula works fine when I have two search terms. But when I add a third search term, I get a #value error. Any help is much appreciated. Good one...

Hello Everyone. I need help with the following SUMPRODUCT formula: =SUMPRODUCT(($C$4:$C$13*$E$4:$E$13)*($B$4:$B$13="AA")*($A$4:$A$13="Landings")) What it's basically doing is that it's summing the product of content of array in column C with content of array in column E, provided that the...