I am looking to sum a column of values, summing only values that are
1) is a "Weight" value
2) is greater than 0.001
3) is a unique value in its row
I can achieve the first and second points using SUMIF() and working with arrays (which I have recently learned about), but need help with #3. I am currently summing the data by hand, but as the data grows in rows and columns, I would prefer a more automated method, and one less prone to human error. I'm not sure there is another way to approach this problem other than a cell function?
Attached is a sample of the data. You can see the correct sums in "True total weights". I would like to achieve the same result in the yellow highlighted cells. Currently, values less than 0.001 are expressed in red fonts, and values that are duplicates in its row are highlighted pink.
Bookmarks