Query Function Table with total row
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVW
1
Query Function Table with total row
2
3
Created by Ben Collins
4
Read more at:
http://www.benlcollins.com/spreadsheets/query-total-row/
5
6
Feel free to make your own copy so you have editing rights.
7
File > Make a copy...
8
9
Raw DataStandard Query TableQuery Table with total row - STATIC
Query Table with total row - DYNAMIC
Query Table with total row - DYNAMIC, VERSION 2 ALTERNATIVE
Query Table with WHERE filter on everything starting with DEPT.
10
Table will expand or contract if data is added or removed
Table will expand or contract if data is added or removed
Table will expand or contract if data is added or removed
11
Agency# Of PositionsAgencyTotal PositionsAgencyTotal PositionsAgencyTotal PositionsAgencyTotal PositionsAgencyTotal Positions
12
DEPT OF INFO TECH & TELECOMM1NYC HOUSING AUTHORITY125NYC HOUSING AUTHORITY125NYC HOUSING AUTHORITY125NYC HOUSING AUTHORITY125
DEPT OF ENVIRONMENT PROTECTION
37
13
DEPT OF HEALTH/MENTAL HYGIENE12DEPT OF ENVIRONMENT PROTECTION37DEPT OF ENVIRONMENT PROTECTION37DEPT OF ENVIRONMENT PROTECTION37DEPT OF ENVIRONMENT PROTECTION37
DEPT OF HEALTH/MENTAL HYGIENE
24
14
DEPARTMENT OF FINANCE1DEPT OF HEALTH/MENTAL HYGIENE24DEPT OF HEALTH/MENTAL HYGIENE24DEPT OF HEALTH/MENTAL HYGIENE24DEPT OF HEALTH/MENTAL HYGIENE24
DEPT OF INFO TECH & TELECOMM
3
15
DEPT OF ENVIRONMENT PROTECTION1ADMIN FOR CHILDREN'S SVCS6ADMIN FOR CHILDREN'S SVCS6ADMIN FOR CHILDREN'S SVCS6ADMIN FOR CHILDREN'S SVCS6TOTAL64
16
DEPT OF HEALTH/MENTAL HYGIENE1DEPT OF INFO TECH & TELECOMM3DEPT OF INFO TECH & TELECOMM3DEPT OF INFO TECH & TELECOMM3DEPT OF INFO TECH & TELECOMM3
17
DEPT OF HEALTH/MENTAL HYGIENE4DEPARTMENT OF BUSINESS SERV.2DEPARTMENT OF BUSINESS SERV.2DEPARTMENT OF BUSINESS SERV.2DEPARTMENT OF BUSINESS SERV.2
18
DEPT OF ENVIRONMENT PROTECTION1LAW DEPARTMENT2LAW DEPARTMENT2LAW DEPARTMENT2LAW DEPARTMENT2
19
NYC HOUSING AUTHORITY1TAXI & LIMOUSINE COMMISSION2TAXI & LIMOUSINE COMMISSION2TAXI & LIMOUSINE COMMISSION2TAXI & LIMOUSINE COMMISSION2
20
DEPT OF ENVIRONMENT PROTECTION4DEPARTMENT OF FINANCE1DEPARTMENT OF FINANCE1DEPARTMENT OF FINANCE1DEPARTMENT OF FINANCE1
21
LAW DEPARTMENT1DEPARTMENT OF TRANSPORTATION1DEPARTMENT OF TRANSPORTATION1DEPARTMENT OF TRANSPORTATION1DEPARTMENT OF TRANSPORTATION1
22
DEPT OF ENVIRONMENT PROTECTION1TOTAL203TOTAL203TOTAL203
23
DEPT OF HEALTH/MENTAL HYGIENE1
24
DEPT OF HEALTH/MENTAL HYGIENE1
25
NYC HOUSING AUTHORITY3
26
DEPT OF HEALTH/MENTAL HYGIENE2
27
DEPT OF HEALTH/MENTAL HYGIENE1
28
NYC HOUSING AUTHORITY4
29
NYC HOUSING AUTHORITY4
30
DEPT OF ENVIRONMENT PROTECTION1
31
DEPT OF ENVIRONMENT PROTECTION11
32
DEPT OF ENVIRONMENT PROTECTION1
33
ADMIN FOR CHILDREN'S SVCS1
34
DEPT OF INFO TECH & TELECOMM1
35
ADMIN FOR CHILDREN'S SVCS4
36
DEPT OF ENVIRONMENT PROTECTION1
37
NYC HOUSING AUTHORITY6
38
DEPARTMENT OF BUSINESS SERV.1
39
DEPARTMENT OF BUSINESS SERV.1
40
DEPT OF ENVIRONMENT PROTECTION1
41
DEPT OF ENVIRONMENT PROTECTION5
42
DEPT OF ENVIRONMENT PROTECTION1
43
DEPT OF ENVIRONMENT PROTECTION1
44
DEPARTMENT OF TRANSPORTATION1
45
DEPT OF ENVIRONMENT PROTECTION1
46
DEPT OF ENVIRONMENT PROTECTION1
47
LAW DEPARTMENT1
48
DEPT OF ENVIRONMENT PROTECTION1
49
DEPT OF HEALTH/MENTAL HYGIENE1
50
DEPT OF ENVIRONMENT PROTECTION1
51
DEPT OF ENVIRONMENT PROTECTION1
52
DEPT OF ENVIRONMENT PROTECTION1
53
NYC HOUSING AUTHORITY5
54
NYC HOUSING AUTHORITY50
55
NYC HOUSING AUTHORITY52
56
DEPT OF HEALTH/MENTAL HYGIENE1
57
TAXI & LIMOUSINE COMMISSION2
58
ADMIN FOR CHILDREN'S SVCS1
59
DEPT OF ENVIRONMENT PROTECTION1
60
DEPT OF ENVIRONMENT PROTECTION1
61
DEPT OF INFO TECH & TELECOMM1
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...