SUM totals of VLOOKUP

Looking for help on a formula.

I need the Forecast Adjustment column on (A) to add all amounts pulling (B). These should total $13,416.67, however, it it showing as $5,416.67. Please help! How do I change the formula to sum the VLOOKUPS?


Forecast Adjustment forumla =IFERROR(VLOOKUP(Category@row, {Table Category_Full Table}, 6, false), 0)



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!