Sum if and Vlookup

Hello there,

I need to add all quantities of a column which have similar characteristics mentioned in another column. It must be very easy but I couldn't do it.

I am going to use a VLOOKUP command to find all the items of similar type, then add them. Something which I thought can be done by a SUMIF(VLOOKUP.... formula. But ..!

Can any one help?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!