Sum VLOOKUP
Hi there. I’d like to create a cell in a different sheet that shows the total for the Amazon amounts. The table below will get populated via a form so the cell needs to be able to look for the given value - Amazon and then total the amounts. I was thinking there might be a SUM(VLOOKUP) function or similar I could use but it keeps just returning the top value. Can anyone help? I’m actually on an iPad Pro too, not Mac so that might complicate further but if you only know Mac then the formula would be great and I can try it in IPad Pro Numbers. Thanks.