# Worksheets: formula for counting number of items

## Recommended Posts

I have a small Worksheet which I want to show simply the number of types of each item:

Record format = "Door Schedule"

Field name = "Type"

Types = A through to H

So for one column I tried this, but it doesn't like it:

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

What should I be doing to get the number of Type A?

try double (( enclosures

• Vectorworks, Inc Employee

Use:

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

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

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

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.

Hmm, I'm trying to add Layer now too:

(((L='1st FLOOR') & ('Door Schedule'.'Type'='A')))

But this didn't work.

Thanks for the colrow tip Petri.

Oh dear, I forgot to append =count

It's Friday evening. Time to go for a beer.

• 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

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

×   Pasted as rich text.   Restore formatting

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×

• KBASE
• #### MARIONETTE

×
• Create New...