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
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!