I am trying to create a worksheet that sums the total length of lines in certain classes. Ideally, I would like to do this via a database instead of using spreadsheet mode and a formula.
In the attached worksheet I have set up 3 classes with 3 lines each. I have built databases for each class. I want to summarize the data so that instead of showing each of the 3 lines and their lengths as separate rows, the contents of the database is summarized as a single row (IE row 5.1 would display "Class A" in column A & "30" in column B.
If I try to summarize Column A using the Summarize Items function it summarizes the 3 rows down to a single row which displays "Class A" in column A but only displays "---" in column B. No other combination of the Summarize Items & Sum functions seems to get me what I want.
Am I stuck using formulas or is there a way around this that would allow me to use a database.
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.
Question
GlueDT92
I am trying to create a worksheet that sums the total length of lines in certain classes. Ideally, I would like to do this via a database instead of using spreadsheet mode and a formula.
In the attached worksheet I have set up 3 classes with 3 lines each. I have built databases for each class. I want to summarize the data so that instead of showing each of the 3 lines and their lengths as separate rows, the contents of the database is summarized as a single row (IE row 5.1 would display "Class A" in column A & "30" in column B.
If I try to summarize Column A using the Summarize Items function it summarizes the 3 rows down to a single row which displays "Class A" in column A but only displays "---" in column B. No other combination of the Summarize Items & Sum functions seems to get me what I want.
Am I stuck using formulas or is there a way around this that would allow me to use a database.
Line Lengths Worksheet.vwx
Edited by GlueDT92Updated to correct file
Link to comment
2 answers to this question
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.