Nach einigem Googeln bin ich zumindest mal auf diese funktionierende Lösung gestoßen:
=AVERAGE(importrange("KEY",concatenate(A1,"!D114:121")))
____________________________________
"Life is like a box of rockets," said the Marine. "You never know what you´re gonna ret."
Then he pulled the trigger of his BFG9000.
|