How to sum an Index/Match

BFuller

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!

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?