Jump to content

Working out averages for databases in worksheets


Recommended Posts

My brain must have temporarily stopped working because I cant think of a way to do this and Im pretty sure its easy.

I have a database in my worksheet, the criteria is set to retrieve all objects whose type is walls.

In Column A I have used <=LENGTH>

I want to work out the average length of all my walls.

Now, at the moment there are 10 walls, I know I could simply use an equation , since A1 (header of database) shows the total length and there are 10 walls

But if I add a new wall I would have to change the 10 to an 11.

The equation would need to read

I know I could set the criteria twice (once for the database, once for the average equation) but this would mean updating multiple criterias if anything needed changing.

Hope all that makes sense.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...