How to count number of lines and contents

1st -

I would like to be able to have a formula to count the total number of doors surveyed

You can try something like:

count(select tablename)

2nd -

I would like to have a formula to count the number of doors that are compliant

Then you can do, replace tablename and isCompliant with your respective table name and field name:

count(select tablename where isCompliant

3rd -

I would like to have a formula to count the number of doors are not compliant

Lastly, you can try:

count(select tablename where not isCompliant

Another question:

I see from your picture that you have a lot of tables that start with 3.00 then 3.10 then 3.20 etc. Are the data in the tables so vastly different that you need a new table to store it? If I made a DB of my company vehicles, I could do a separate table for ground vehicles, air vehicles and water vehicles. What would make more sense is to put them all in one then I can easily do a count of my company vehicles. I can separate them based on a field that tracks ground, air, water. Using that field I can also display other fields that could be specific to the vehicle type.

If the only data that is different between the tables is the first part of the table name then may I recommend that you create a new choice field and merge all the tables into one and use that new choice field to separate the records. This will make finding records on Fire Door Information a lot easier now that you only have 1 table to search.

Peter Oram said:
So, formulas 2 & 3 would now need to be how many cells are populated in a certain column.  If you can assist with that, that would be great.

 The formulas I wrote do what you ask do they not?