SUMIF, INDEX, MATCH and Calculate percentage formula

If a column has a specific value "A&D Fee", I want to go find a column in another sheet "Design Fee", MATCH the Master RE ID numbers and then find 5% of that value. This is the formula I've tried but it does not work. Can anyone offer some suggestions? Thank you.

=SUMIF(Type@row = "A&D Fee", (INDEX({Design Fee}, MATCH([Master RE ID]@row, {TOK RE ID} * 0.05, 0))))))

Find more posts tagged with

Accepted answers

All comments

Colleen Patterson

@Dana S

I normally write that expression as:

=IF(Type@row = "A&D Fee", (SUMIF({Master RE ID}, [Master RE ID]@row, {TOK RE ID}) * 0.05), 0)

Where:

{Master RE ID} is that column from the Design Sheet
[Master RE ID]@row points to the row within the sheet that you are doing the calculation
{TOK RE ID} is the column in the Design Fee sheet where you are storing the number that you need the 5% calculation performed.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.