I’m probably just missing how to do this, but is there a way to add the values returned in a lookup cell?
I have multiple rows with different data in one column. Is there a way to pull those values in and add them (SUM) in a different sheet? I’ve used the lookup functionality to pull these numbers into a single cell based on the relational data, but I’m stuck on how to add these together into a single result/cell from here. ie, Rather than having 1 5 10 as three separate numbers, how do I get a cell that shows 16 based on what I’m pulling in with the relational/lookup pulls.