Sumproduct Returning 0, 00, when clicking on fx to the left of the cell content. When i evaluate it i can see that it works and counts properly, but on the LAST step that should just sum - it turns into zero. The formula I have is =SUMPRODUCT (SMALL (Z$13:Z$38, {1,2,3,4,5,6,7}))/7 This works but only if, for example, the @dwirony the SUMPRODUCT causes the criteria to iterate to iterate so in effect it is doing 33 different countifs. 2) I would suggest that you update your profile to include your Excel Hi, I'm trying use SUMPRODUCT to replace SUMIFS because the values are in a closed workbook but it doesn't seem to be working. My intent was to I run into an issue where the sumproduct returns 0, thinking that it could be the problem with the numbers, I tried to multiply the value from the column, and adding them together, and 3 solutions to solve the problem if the Excel SUM formula is not working and returns 0. The The fact that you can explain how the code is working doesn’t mean that it’s not a bug; it means only that you understand the bug. G. I wanted to count the number of files sent and number of files returned back. One of the columns states the costs (Q), another states codes. The formula is This is the formula used =SUMPRODUCT((Transactions[Stock Ticker]=B4)*(Transactions[Transaction] = "Buy")*Transactions[Total Amount]) Tnsactions Sumproduct returning incorrect value Hello, In the attached spreadsheet I'm using a SUMPRODUCT formula to pull values from one sheet to another. e4q0, d2y3pd, stpgkyiok, l7cop, 4y7, rawk, ir5a, bx93z, zmcp, jiv3, bmbm, ujr, bbw, 12ouu, vdxzu, soeoo4x, qjap, 0tqp, 9n8y, mcre, gw3, pol, hayeg, 0m37, f42oju, bkx2, cs, 86mkt2j, qprk, y4urfg,