Spreadsheet: 858224d1706960982-embedding-max-min-in-sumproduct-formula-sjpeters75-opportunity-calculator-revised-ans2
Sheet: Sheet1

Opportunities |  |  |  |  |  |  | Holidays
Contract | Rev/hr | Start | End |  |  |  | 2024-01-01 00:00:00
Contract 1 | 1 | 2024-01-01 00:00:00 | 2024-07-06 00:00:00 |  |  |  | 2024-01-15 00:00:00
Contract 1 | 2 | 2024-05-01 00:00:00 | 2024-12-09 00:00:00 |  |  |  | 2024-02-19 00:00:00
Contract 2 | 1 | 2024-09-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  | 2024-05-27 00:00:00
Contract 3 | 1 | 2024-02-04 00:00:00 | 2024-02-08 00:00:00 |  |  |  | 2024-06-19 00:00:00
 |  |  |  |  |  |  | 2024-07-04 00:00:00
 |  |  |  |  |  |  | 2024-09-02 00:00:00
 |  |  |  |  |  |  | 2024-10-14 00:00:00
 |  |  |  |  |  |  | 2024-11-11 00:00:00
 |  |  |  |  |  |  | 2024-11-28 00:00:00
 |  |  |  |  |  |  | 2024-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 |  |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 |  |  | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 168 | 160 | 168 | 176 | 528 | 456 | 384 | 352 | 320 | 352 | 304 | 96
Contract 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 160 | 176 | 152 | 168
Contract 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 3 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Contract 3
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Contract 1 | 168 | 160 | 168 | 176 | 528 | 456 | 384 | 352 | 320 | 352 | 304 | 96
Contract 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Contract 3 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Contract 1 (Row 3)
Contract 1 (Row 4)
Total Opportunities Contract 1