first time poster here.
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 returned the expected results.
Hoping to see if anyone here have any ideas on what’s wrong.
Using cell G100 as example, it was calculated by the following:
- Col D * Col H = Col J
- Sum all values from J2:J17
- This create a “manual version” of sumproduct with expected value of 8681
New contributor
Jere jere is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.