CODEWITHSUNDEEP
excelexcel-formula
agustin
agustin

Reputation: 1351

Excel - Formula - Get n values from resulting array of INDEX

With this table named jobSearches: Table jobSearches

I am able to calculate the Average of the first row using following formula:

=AVERAGE(INDEX(jobsearches,1,))

Note that INDEX(jobsearches,1,) returns an array of values:

Array of values

Question: Is it possible to calculate the AVERAGE for just the first n values of the resolved array, and not for the whole row?

Upvotes: 1

Views: 1698

Answers (2)

g.kov
g.kov

Reputation: 333

That's exactly OFFSET(reference,rows,cols,height,width) function is for:

=AVERAGE(OFFSET(jobsearches,0,1,1,10))

Upvotes: 2

Scott Craner
Scott Craner

Reputation: 152505

You can do something like this:

=AVERAGE(INDEX(jobsearches,1,2):INDEX(jobsearches,1,11))

Which will return the average of the first 10 numbers on the first row.

Upvotes: 3

Related Questions