How to apply ISERROR in an Array Formula

Attached is a simple example of what I’m trying to achieve. There are differing money amounts in column C and the month those amounts are due to be paid in column B. Column E contains an array formula based upon a lookup value in cell G3 (month due for payment). The formula works fine but of course will report #NUM errors when it runs out of values to find from G3. In this example, I wanted J3 to return the total amount due in Jan but of course it also returns a #NUM error as it references the total error in E18. I have tried ISERROR but cannot get it to work – am I on the right track or is there a simpler alternative?

Try IFERROR()

=IFERROR(INDEX($C$3:$C$18, SMALL(IF($G$3=$B$3:$B$18, ROW($B$3:$B$18)-MIN(ROW($B$3:$B$18))+1, ""), ROW(A1)),COLUMN(A1)),"")

Hi kborgers,

See the attached file where I have done the minor correction in the sum formula only. Let me know if this helps.

Regards,
DILIPandey

<click on below 'star' if this helps>

You are welcome kborgers..

Cheers

Happy learning.

Regards,
DILIPandey

<click on below 'star' if this helps>