Is it an earned run if...?

If it is judged that the error prevented the third out of the inning then it is an unearned run and no RBI for the batter (only time an error does not allow and RBI to be scored)