Forum Discussion
Solved
Formula Sum Help
I am looking for a formula that will get the sum of each unique item's quantity in a column and put that output in a chosen cell. I currently have this: As you can see, the set of item names ...
beefykenny Normally I would recommend SUMIF, but all of the numeric values in your screenshot appear to be numbers formatted as text, so SUMIF won't work here. As an alternative, you could try SUMPRODUCT with the VALUE function to coerce the text values in column G to numeric values. For example, in cell G11 use the following formula, then copy/drag it down to cell G13:
=SUMPRODUCT(($E$2:$E$9=E11)*VALUE($G$2:$G$9))
=sum(take(unique(filter(c2:g9,e2:e9=e11,0)),,-1))
- This function isn't valid 🤔