domer1322 Posted September 18, 2013 Share Posted September 18, 2013 I don't use worksheets often, and have this simple question ..... I'm trying to get a sum of all the occupants in spaces, and the database row keeps showing the total number of records, (that is, the number of spaces) instead of the total number of occupants. I've tried and tried to use the "sum" function, to no avail. I'm obviously missing something simple. Please help. Oddly, i've done this worksheet on a previous project, and I duplicate the criteria and function syntax, but it still doesn't give me the 'sum'. Quote Link to comment
Hippocode Posted September 18, 2013 Share Posted September 18, 2013 Make sure the occupant number of each is loaded in one column and sweap the "sum" tag onto it ? Quote Link to comment
domer1322 Posted September 18, 2013 Author Share Posted September 18, 2013 Hippothamus: I've tried that multiple times .... perhaps I'm not selecting the right cell/row but I've tried many options and it just isn't working. Any other suggestions anyone ? Quote Link to comment
Hippocode Posted September 18, 2013 Share Posted September 18, 2013 wel is the occupant "field" a string or an integer ? In case of string rewrite it as "=value(space.occ)". And you shouldn't need the SUM actually. The database row should give the summed result, IF its an integer ! For text it returns the number of objects. Quote Link to comment
domer1322 Posted September 19, 2013 Author Share Posted September 19, 2013 I'm still lost. When I choose "format cells" there are many options but none of them are "string" nor "integer". I don't know where to change the occupant field to be an integer. Quote Link to comment
Hippocode Posted September 19, 2013 Share Posted September 19, 2013 (edited) I'm still lost. When I choose "format cells" there are many options but none of them are "string" nor "integer". I don't know where to change the occupant field to be an integer. Its not the cell but the data itself. you have a database row with criteria loading your objects. Each column loads a field, for example "=space.area". ( formula of one of the columns of your database header row ) The sheet will make a sum of each area in the head database row above all the subrows ( make it visible if not ). This won't work if that specific data, in this case area is plain text. If so, change the column formula into =value(space.area) and it will turn into an integer or real ( not sure about those 2 ). Edited September 19, 2013 by hippothamus Quote Link to comment
domer1322 Posted September 19, 2013 Author Share Posted September 19, 2013 OK ... I think I got it now .... the key is to insert the word "Value" before the criteria in the formula bar .... Thanks a lot for your help .... 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.