Spreadsheet: 96877d1296139881-countifs-to-get-criteria-from-a-cell-reference-capacity
Sheet: Capacity

 | January | February | March | April | May | June | July | August | September | October | November | December
# Head count | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
# Commission Tools | 0 | 1 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5
Weekly Capacity | 60 | 67 | 90 | 103 | 103 | 103 | 120 | 120 | 120 | 180 | 180 | 180
Monthly Capacity | 260 | 289 | 390 | 446 | 446 | 446 | 520 | 520 | 520 | 780 | 780 | 780
Week number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
From Date | 2011-01-03 00:00:00 | 2011-01-10 00:00:00 | 2011-01-17 00:00:00 | 2011-01-24 00:00:00 | 2011-01-31 00:00:00 | 2011-02-07 00:00:00 | 2011-02-14 00:00:00 | 2011-02-21 00:00:00 | 2011-02-28 00:00:00 | 2011-03-07 00:00:00 | 2011-03-14 00:00:00 | 2011-03-21 00:00:00 | 2011-03-28 00:00:00 | 2011-04-04 00:00:00 | 2011-04-11 00:00:00 | 2011-04-18 00:00:00 | 2011-04-25 00:00:00 | 2011-05-02 00:00:00 | 2011-05-09 00:00:00 | 2011-05-16 00:00:00 | 2011-05-23 00:00:00 | 2011-05-30 00:00:00 | 2011-06-06 00:00:00 | 2011-06-13 00:00:00 | 2011-06-20 00:00:00 | 2011-06-27 00:00:00 | 2011-07-04 00:00:00 | 2011-07-11 00:00:00 | 2011-07-18 00:00:00 | 2011-07-25 00:00:00 | 2011-08-01 00:00:00 | 2011-08-08 00:00:00 | 2011-08-15 00:00:00 | 2011-08-22 00:00:00 | 2011-08-29 00:00:00 | 2011-09-05 00:00:00 | 2011-09-12 00:00:00 | 2011-09-19 00:00:00 | 2011-09-26 00:00:00 | 2011-10-03 00:00:00 | 2011-10-10 00:00:00 | 2011-10-17 00:00:00 | 2011-10-24 00:00:00 | 2011-10-31 00:00:00 | 2011-11-07 00:00:00 | 2011-11-14 00:00:00 | 2011-11-21 00:00:00 | 2011-11-28 00:00:00 | 2011-12-05 00:00:00 | 2011-12-12 00:00:00 | 2011-12-19 00:00:00 | 2011-12-26 00:00:00
To Date | 2011-01-09 00:00:00 | 2011-01-16 00:00:00 | 2011-01-23 00:00:00 | 2011-01-30 00:00:00 | 2011-02-06 00:00:00 | 2011-02-13 00:00:00 | 2011-02-20 00:00:00 | 2011-02-27 00:00:00 | 2011-03-06 00:00:00 | 2011-03-13 00:00:00 | 2011-03-20 00:00:00 | 2011-03-27 00:00:00 | 2011-04-03 00:00:00 | 2011-04-10 00:00:00 | 2011-04-17 00:00:00 | 2011-04-24 00:00:00 | 2011-05-01 00:00:00 | 2011-05-08 00:00:00 | 2011-05-15 00:00:00 | 2011-05-22 00:00:00 | 2011-05-29 00:00:00 | 2011-06-05 00:00:00 | 2011-06-12 00:00:00 | 2011-06-19 00:00:00 | 2011-06-26 00:00:00 | 2011-07-03 00:00:00 | 2011-07-10 00:00:00 | 2011-07-17 00:00:00 | 2011-07-24 00:00:00 | 2011-07-31 00:00:00 | 2011-08-07 00:00:00 | 2011-08-14 00:00:00 | 2011-08-21 00:00:00 | 2011-08-28 00:00:00 | 2011-09-04 00:00:00 | 2011-09-11 00:00:00 | 2011-09-18 00:00:00 | 2011-09-25 00:00:00 | 2011-10-02 00:00:00 | 2011-10-09 00:00:00 | 2011-10-16 00:00:00 | 2011-10-23 00:00:00 | 2011-10-30 00:00:00 | 2011-11-06 00:00:00 | 2011-11-13 00:00:00 | 2011-11-20 00:00:00 | 2011-11-27 00:00:00 | 2011-12-04 00:00:00 | 2011-12-11 00:00:00 | 2011-12-18 00:00:00 | 2011-12-25 00:00:00 | 2012-01-01 00:00:00
# Head count | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
# Commission Tools | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Weekly Capacity | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 67 | 67 | 67 | 75 | 75 | 75 | 103 | 103 | 103 | 103 | 103 | 103 | 103 | 103 |  | 103 | 103 | 103 | 103 |  | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 |  | 120 | 120 | 120 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 |  | 180 | 180 | 180
Scheduled Commissions
Sales Orders
Available Capacity
>90% Opportunities
Available Capacity
75% Opportunities
Available Capacity
50% Opportunities
Available Capacity
Actual Commissions | 21 | 13 | 27 | 13
% of Capacity