Index Match needs to return the sum of the results not just first found

[olvvlo]

I'm trying to find a formula that will return the sum of all matches, not just the first found. This is the formula I'm using at present.

=IFERROR(INDEX($AK$4:$AK$450,MATCH(Z310,$AJ$4:$AJ$450,0)),"")

Can it be modified or is there another way to achieve this?
I'm using Mac 2011 V14

 

[gaz_chops]

Welcome to the forum, try

=sumifs($AK$4:$AK$450,$AJ$4:$AJ$450,Z310)

 

[olvvlo]

Thank you this works
Saved me hours of frustration.

 

[gaz_chops]

You're welcome, thanks for the feedback.