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!
Answers
-
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!
If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!