markdd Posted July 5, 2019 Share Posted July 5, 2019 I wish I could remember how to do this! I am trying to get a total number of Ropes in Column E where there is currently a 0. Could someone remind me what the formala would be for that? Many thanks Quote Link to comment
0 Pat Stanford Posted July 5, 2019 Share Posted July 5, 2019 Total guess here, but based on the Left alignment of the numbers in column E and the count in the header row of E2=3, it looks like they are formatted at text instead of as numbers. Try changing them to be formatted as numbers (Worksheet Format menu:Cells, Decimal with 0 decimal points). The Header Row (E2) should give you the sum of the numbers in the column. If you want to be able to hide the header row, you can still access that data. Just set E4 to =E2. 1 Quote Link to comment
0 markdd Posted July 5, 2019 Author Share Posted July 5, 2019 Thanks Pat. I tried that - no good I'm afraid. I've included the objects in a clean file. If you could take a look I'd be really grateful. Maybe the Stanchion objects don't report numbers? Worksheet Problem.vwx Many thanks Mark Quote Link to comment
0 Pat Stanford Posted July 5, 2019 Share Posted July 5, 2019 It is as I suspected. The TTLRopes field is formatted as text. Change the formula in cell E2 to: =VALUE('Rope and Stanchion'.'TTLRopes') This will give you a numeric version that can be totaled. 1 Quote Link to comment
0 markdd Posted July 5, 2019 Author Share Posted July 5, 2019 That is such a great tip. Thanks. Should these tools that report numbers which are clearly intended for worksheets, not be formatted as numbers? I think its the same for all the Stage deck tools as well as the Stage Lift tool. Most grateful as ever Mark Quote Link to comment
0 Pat Stanford Posted July 5, 2019 Share Posted July 5, 2019 I certainly think so. I end up answering a question like this almost monthly. There are certainly some benefits to the programmer doing it this way. If they were formatted as a number they would have to deal with what to do when someone changed that number from the worksheet or else the number in the worksheet would be different than what the object requires. This was handled in the Space object by adding a second field that had the numeric version as well as the canonical text version. If the numeric version was changed it would just reset back to match the text version the next time the object was reset. Quote Link to comment
0 markdd Posted July 5, 2019 Author Share Posted July 5, 2019 Interesting. Some of the fields in these objects are "two-way" and some are not. Many thanks again. Mark Quote Link to comment
Question
markdd
I wish I could remember how to do this!
I am trying to get a total number of Ropes in Column E where there is currently a 0. Could someone remind me what the formala would be for that?
Many thanks
Link to comment
6 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.