I want to use the `ARRAYFORMULA` version of 

    =AVERAGE(Linda!B3, Nandi!B3, David!B3, Remmelt!B3)

I want the cell to calculate the average value of the entries in that cell from the other tabs (Linda, Nandi, David, Remmelt). I need to use `AVERAGE` and not just sum and division, because I need to deal with the fact that not everyone will enter values in all cells.

I tried using

    =ARRAYFORMULA(AVERAGE(Linda!B3:B, Nandi!B3:B, David!B3:B, Remmelt!B3:B))

but then it average over all four columns, not just the four cells I want.

**Edit:** As far as I understand `ARRAYFORMULA` takes an input of type array and displays it over as many cells. So the problem comes down to making `AVERAGE` (or similar) output an array.

Thanks, <br>
Linda