Monday, September 18, 2017

yogi_WorkAround For ArrayFormula With AVERAGEIFS

Google Spreadsheet   Post  #2241

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-18-2017
question by: Jan Laurencik

ARRAYFORMULA with AVERAGEIFS

Hello,
how to use ARRAYFORMULA with AVERAGEIFS? The formula =arrayformula(averageifs(C3:C,E3:E,G3:G,D3:D,"FT")) only spreads into one cell, not to entire column. I have tested it also with AVERAGEIF but with same result.
Thank you very much for your kind help.
Jan