Worksheets: formula for counting number of items

[Christiaan]

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?

[jfmarch]

try double (( enclosures

[Robert Anderson]

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.

[Christiaan]

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

[Petri]

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.

[Christiaan]

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.

[Christiaan]

Oh dear, I forgot to append =count

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

[techdef]

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