sFloor | sRoom

At the end of most functions, you have the option of including a list of strings specifying rooms and floors to which the count should be restricted. All devices that are found in any of the listed rooms or floors will be included in the count.

Floors are specified with a string starting with "FLOOR:" and then the floor to include. For example, "FLOOR:One" will include all devices on floor One.

Rooms are specified with a string starting with "ROOM:" and then the room to include. For example, "ROOM:101" will include all devices in room 101.

Examples

=LightFixtureCount1('DM Elec'!$B$1, "A", "", "")

This function will return the count of light fixtures on all floors and rooms in the project.

=LightFixtureCount1('DM Elec'!$B$1, "A", "", "", "FLOOR:Two")

This function will return the count of light fixtures on floor Two.

=LightFixtureCount1('DM Elec'!$B$1, "A", "", "", "ROOM:102")

This function will return the count of light fixtures in room 102.

=LightFixtureCount1('DM Elec'!$B$1, "A", "", "", "FLOOR:Two", "ROOM:102")

This function will return the count of light fixtures that are either on floor Two or in room 102.

=LightFixtureCount1('DM Elec'!$B$1, "A", "", "", "FLOOR:Two", "ROOM:102", "ROOM:103")

This function will return the count of light fixtures that are either on floor Two, or in room 102, or in room 103.