Jump to content

Hello Community!

This Thursday, October 21st, from 6 pm to 7 pm EDT, we will be performing an update on the Vectorworks Community Board. During this time, the site will be unavailable.

Worksheets: formula for counting number of items


Recommended Posts

=COUNT('Door Schedule'.'Type'='A')

It was just the equals sign I had in the wrong position. Don't need the single quotes around Type and A.

This formula probably works better (i.e. is more meaningful) in a single calculation cell rather than in a database row.

Ha, boy, sometimes I can make things difficult for myself! Thanks.

Link to comment

Christiaan,

I have a very strong recollection that especially single-cell formulae can use a cell reference quite well in the query.

Thus, =count('door schedule'.'type'=colrow) (colrow = eg A2) could work. If I'm right, you could just type "A" in cell A2 and the Tallyman would do the counting.

Link to comment
  • 14 years later...

Picking this back up - I'd like to filter Parking Spaces by size, ie: to separate out Standard from Compact (and possibly also by story).

 

Looking at the above, and tried:

 

=COUNT(IF((B3>=18), 1, 0))

 

which somehow yielded 9409. Perhaps the If function doesnt like feet and inches?

 

Long story short, the first pass would be a cell which displays Number of Spaces >= 18' x 8'-6" and a cell for Number of Spaces < 18' x 8'-6"

 

thanks

 

Screen Shot 2021-07-08 at 2.04.46 PM.png

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...