How to sum an Index/Match


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!


  • Scott Orsey
    Scott Orsey ✭✭✭✭✭
    edited 04/02/24

    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
    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?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!