Try this:-
*=ARRAYFORMULA(AVERAGE(LARGE({Q9,V9,AA9,AF9,AK9,AP9},{1,2,3}))) *
On Wednesday, July 27, 2022 at 11:41:22 AM UTC+5:30 [email protected]
wrote:
> hey everyone. have a syntax error on trying to get the top 3 values of my
> spreadsheet of certain cells that aren't adjacent and average them
> together. can you help see if this is close. this is what i have
> inputted.......
>
> =AVERAGE(LARGE((Q9,V9,AA9,AF9,AK9,AP9),{1,2,3}))
>
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-spreadsheets-api/f339db70-ecae-4db8-b7f5-15e497bdcf34n%40googlegroups.com.
