CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
itsover9000
itsover9000

Reputation: 611

Get an Average of a row with dynamic columns in google sheets

Is there a way to get the average of a row in google sheets with dynamic columns?

for example i have the following data

in cell A2 im using the formula

=AVG(B2:AA2)

but it returns as #NAME?

i know it works if its just

=AVG(B2:D2)

but i need the columns to be dynamic

is there a way to do this?

Upvotes: 0

Views: 327

Answers (1)

marikamitsos
marikamitsos

Reputation: 10573

About =AVG(B2:D2)
In Google sheets there is no such function.
That is the reason you see the error #NAME?

Instead you have to use

=AVERAGE(B2:AA2)

Upvotes: 1

Related Questions