Timeline for How to use AVERAGE inside ARRAYFORMULA in Google Sheets
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 31, 2021 at 2:07 | comment | added | oshliaer | @rh-becker it's doesn't work like expected. | |
| May 31, 2021 at 2:03 | comment | added | oshliaer |
@Tedinoz, yep, it's true. But it's not like ARRAYFORMULA. Just the first argument of INDEX is iterable. And this works like ARRAYFORMULA.
|
|
| Apr 26, 2021 at 6:36 | comment | added | Tedinoz |
Are you saying that =INDEX(AVERAGEIF(YEAR(monthly!$A$2:$A), 2021, monthly!$B$2:$B)) works like an arrayformula?
|
|
| Apr 21, 2021 at 20:53 | history | edited | RH Becker | CC BY-SA 4.0 |
added 4 characters in body
|
| Apr 21, 2021 at 20:50 | review | First posts | |||
| Apr 22, 2021 at 10:45 | |||||
| Apr 21, 2021 at 20:47 | history | answered | RH Becker | CC BY-SA 4.0 |