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?

(A):

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

(B):

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

Use a SUMIFS instead.

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

All comments

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! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.