69739

Calculate average of numbers in a column using column number

Question:

I am trying to find a way of calculating the average of numbers in a column using the column's number. For example, I know that the average of numbers in column E can be obtained using the formula AVERAGE(E:E), but what if I need to use the column number (in this case 5) to calculate that average?

Thanks in advance,

Answer1:

Use INDEX()

=AVERAGE(INDEX($1:$1048576,0,5))

Change the 5 to the column number of your choice.

The 0 returns the whole column

<a href="https://i.stack.imgur.com/E1ufq.png" rel="nofollow"><img alt="enter image description here" class="b-lazy" data-src="https://i.stack.imgur.com/E1ufq.png" data-original="https://i.stack.imgur.com/E1ufq.png" src="https://etrip.eimg.top/images/2019/05/07/timg.gif" /></a>

Recommend

  • How to store result of stored procedure in a variable using SQL Server
  • complex annotate on django query set
  • javafx 3d performance large data set
  • Why does the first run of “XCTestCase -measureBlock:” takes so much time?
  • How to delete column from range if cell contains specific value in VBA/Excel
  • Taking mean across rows grouped by a variable in numpy
  • Aggregate all dataframe row pair combinations using pandas
  • Differences between drawing an Ellipse in Android and Java
  • What exactly is the height of modalPresentationStyle - FormSheet on iPad?
  • Calling java project from Mathematica
  • Neo4j: Filter nodes based on aggregate function
  • calculating number of bytes of each row in an image
  • Excel distinct count with conditions
  • Click on button in another program - FindWindow, C#
  • How to create CGPath from a SKSpriteNode in SWIFT
  • Groovy: Unexpected token “:”
  • Replace value with Factor in r data.table
  • How to access EntityManager inside Entity class in EJB3
  • Repeat a vertical line on every page in Report Builder / SSRS
  • Is there a javascript serializer for JSON.Net?
  • PHPUnit_Framework_TestCase class is not available. Fix… - Makegood , Eclipse
  • Splitting given String into two variables - php
  • NetLogo BehaviorSpace - Measure runs using reporters
  • Is my CUDA kernel really runs on device or is being mistekenly executed by host in emulation?
  • DotNetZip - Calculate final zip size before calling Save(stream)
  • Where to put my custom functions in Wordpress?
  • Build own AppleScript numerical error handling
  • Rearranging Cells in UITableView Bug & Saving Changes
  • Calling of Constructors in a Java
  • Traverse Array and Display in markup
  • Transpose CSV data with awk (pivot transformation)
  • Buffer size for converting unsigned long to string
  • Proper way to use connect-multiparty with express.js?
  • Why can't I rebase on to an ancestor of source changesets if on a different branch?
  • How can I remove ASP.NET Designer.cs files?
  • python draw pie shapes with colour filled
  • Is there any way to bind data to data.frame by some index?
  • Binding checkboxes to object values in AngularJs
  • How can i traverse a binary tree from right to left in java?
  • Conditional In-Line CSS for IE and Others?