In Google Sheets I have a string like this: "G4;G15;G26;G37;G48".

How do I get the average of the values in those cells?

I'm sure there's some arrayformula and indirect to be used, but I can't seem to find the right combo.