With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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.