I’m using Sumproduct to calculate cost of resources per product. It’s a very simple calculation, yet the outcome is not what I expected.
=SUMPRODUCT($D$3:$D$38;F3:F38)
Where column D holds the cost per item and F the number of items used for production of the product. in this case D3 is 0,057 and F3 = 1, D38 = 0,792 and F38 = 1. The outcome should be 0,669, instead it’s 6,690E-1.
I hope someone can tell me what’s going on and come up with a solution.
Screenshot of my formula
I’ve looked up similar issues.
- It turns out there’s a problem using sumproduct with more than 10 decimals, but I don’t have anything more than 5 decimals.
- I thought it might have to do with the fact that there are blanks, so I filled one column up with zero’s. It didn’t help.
- I thought it might have to be used as an array formula, but that didn’t do anything either.
New contributor
imke2u is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.