SUM totals of VLOOKUP

@SPark

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?

(A):

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

(B):

T

Paul Newcome

Use a SUMIFS instead.

=SUMIFS({Sheet B Variance Column}, {Sheet B Sub Category Column}, Category@row)

Paul Newcome

Use a SUMIFS instead.

=SUMIFS({Sheet B Variance Column}, {Sheet B Sub Category Column}, Category@row)

@SPark

Paul, I knew you would come through for me!! :)

Paul Newcome

Haha. Happy to help! 👍️