I’m also noticing that your formula has A2 instead of the array A2:A. Not sure if that would help as like @Christophe_HK said, SUMIFS doesn’t work with array formulas. Only SUMIF does. You may be able to use SUMIF if you join column values together.
Sure thing, they submit a form to ‘Completados’ pending approval, when admin approves Completados!H2:H,TRUE() checks if the email of the submitted form matches the email of the user Completados!B2:B,A2, and then sums the exp coming from all the submitted and approved forms Completados!I2:I
I don’t know if this was exactly how you meant but I fixed it with two separate formulas, one checking each condition and now it works with an arrayformula
Edit: that didn’t work either, was working whether it was approved or not, but I think I could make it with this formula: