How to sum an Index/Match

Hello,

I need to sum an index match formula. Can someone help me?

The following formula works, I just want to add a component to sum the numbers because it is pulling from a sheet in which there will be multiple entries.

=IFERROR(INDEX({Quantity}, MATCH([Request ID]@row, {Request ID}, 0)), "")

Thank you in advance!

Find more posts tagged with

Accepted answers

All comments

Scott Orsey

Hi @BFuller , You'll want SUMIF instead of INDEX/MATCH

=SUMIF({Request ID},[Request ID]@row, {Quantity})

I don't think you'll need the IFERROR()

Hope this helps. Be well!

BFuller

Hi Scott, thanks for the reply.

In this field, I have an index match formula that goes to another sheet and pulls a number from a column. I want it to still do that, but when it finds all the numbers that match, I want it to sum it for me and place it in that field on my first sheet. Is that possible?

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.