CS1 Posted June 24, 2008 Share Posted June 24, 2008 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. Quote Link to comment
Pat Stanford Posted June 25, 2008 Share Posted June 25, 2008 include a column with a formula of =count which will give you the number of objects that have been summed together. For this example consider this to be in cell B1. In cell A1 put a formula of =length. In cell C1 put a formula of =a1/b1 This will give you the average length of the summed walls. Pat Quote Link to comment
Recommended Posts
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.