Spreadsheet: 808119d1670307163-sum-if-based-on-month-type-and-if-cell-is-blank-sample1
Sheet: Sheet1

Project | 2022 Revenue | 2022 GP | 2023 Revenue | 2023 GP | PROJECTED REVENUE JANUARY 2022 | ACTUAL REVENUE JANUARY 2022 | PROJECTED GP JANUARY 2022 | ACTUAL GP JANUARY 2022 | PROJECTED REVENUE FEBRUARY 2022 | ACTUAL REVENUE FEBRUARY 2022 | PROJECTED GP FEBRUARY 2022 | ACTUAL GP FEBRUARY 2022 | PROJECTED REVENUE MARCH 2022 | ACTUAL REVENUE MARCH 2022 | [NAME] MARCH 2022 | ACTUAL GP MARCH 2022 | PROJECTED REVENUE APRIL 2022 | ACTUAL REVENUE APRIL 2022 | PROJECTED GP APRIL 2022 | ACTUAL GP APRIL 2022 | PROJECTED REVENUE MAY 2022 | ACTUAL REVENUE MAY 2022 | [NAME] MAY 2022 | ACTUAL GP MAY 2022 | PROJECTED REVENUE JUNE 2022 | ACTUAL REVENUE JUNE 2022 | PROJECTED GP JUNE 2022 | ACTUAL GP JUNE 2022 | PROJECTED REVENUE JULY 2022 | ACTUAL REVENUE JULY 2022 | PROJECTED GP JULY 2022 | ACTUAL GP JULY 2022 | PROJECTED REVENUE AUGUST 2022 | ACTUAL REVENUE AUGUST 2022 | [NAME] AUGUST 2022 | ACTUAL GP AUGUST 2022 | PROJECTED REVENUE SEPTEMBER 2022 | ACTUAL REVENUE SEPTEMBER 2022 | PROJECTED GP SEPTEMBER 2022 | ACTUAL GP SEPTEMBER 2022 | PROJECTED REVENUE OCTOBER 2022 | ACTUAL REVENUE OCTOBER 2022 | PROJECTED GP OCTOBER 2022 | ACTUAL GP OCTOBER 2022 | PROJECTED REVENUE NOVEMBER 2022 | ACTUAL REVENUE NOVEMBER 2022 | PROJECTED GP NOVEMBER 2022 | ACTUAL GP NOVEMBER 2022 | PROJECTED REVENUE DECEMBER 2022 | ACTUAL REVENUE DECEMBER 2022 | PROJECTED GP DECEMBER 2022 | ACTUAL GP DECEMBER 2022 | PROJECTED REVENUE JANUARY 2023 | ACTUAL REVENUE JANUARY 2023 | PROJECTED GP JANUARY 2023 | ACTUAL GP JANUARY 2023 | PROJECTED REVENUE FEBRUARY 2023 | ACTUAL REVENUE FEBRUARY 2023 | PROJECTED GP FEBRUARY 2023 | ACTUAL GP FEBRUARY 2023 | PROJECTED REVENUE MARCH 2023 | ACTUAL REVENUE MARCH 2023 | [NAME] MARCH 2023 | ACTUAL GP MARCH 2023 | PROJECTED REVENUE APRIL 2023 | ACTUAL REVENUE APRIL 2023 | PROJECTED GP APRIL 2023 | ACTUAL GP APRIL 2023 | PROJECTED REVENUE MAY 2023 | ACTUAL REVENUE MAY 2023 | PROJECTED GP MAY 2023 | ACTUAL GP MAY 2023 | PROJECTED REVENUE JUNE 2023 | ACTUAL REVENUE JUNE 2023 | PROJECTED GP JUNE 2023 | ACTUAL GP JUNE 2023 | PROJECTED REVENUE JULY 2023 | ACTUAL REVENUE JULY 2023 | PROJECTED GP JULY 2023 | ACTUAL GP JULY 2023 | PROJECTED REVENUE AUGUST 2023 | ACTUAL REVENUE AUGUST 2023 | [NAME] AUGUST 2023 | ACTUAL GP AUGUST 2023
Project 1 |  |  |  |  | 102112 | 90605 | 19197.056 | 17036 | 39304 | 97306 | 7566.02 | 40747 | 46534 | 98687 | 8981.062 | 41988 | 0 | 73874 | 0 | 18499 | 42399 | 58455 | 8395.002 | 21714 | 33455 | 38168 | 6684.309 | 12272 | 30208 | 47854 | 6062.745599999999 | 9604 | 32924 | 46396 | 6607.846799999999 | 13857 | 64820 | 104169 | 13061.23 | 86339 | 110000 | 36247 | 23485 | 9789 | 100000 |  |  |  | 100000 |  |  |  | 33896 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Project 2 |  |  |  |  | 0 | 44405 | 0 | -45010 | 0 | 1719 | 0 | 59 | 60000 | 38023 | 0 | -9750 | 60000 | 32281 | 0 | -62570 | 30000 | 29029 | 0 | -2579 | 10000 | 3139 | 0 | -14333 | 19377.9 | 16357 | 0 | -7780 | 0 | 5798 | 0 | -214 | 6000 | 6145 | 78 | 81 | 0 | 1 | 0 | 0 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 34449.6 |  |  |  | 51674.39999999999 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Project 3 |  |  |  |  | 301111 | 288740 | 66425 | 50798 | 267795 | 505653 | 57897.279 | 106990 | 332042 | 342360 | 71787.4804 | 91210 | 153876 | 339184 | 33883.4952 | 158617 | 12841 | 26385 | 3058.7262 | 6284 | 0 | -889 | 0 | -212 | 52990 | 4325 | 12622.218 | 1237 | 20088 | 11404 | 4784.9616 | 5014 | 0 | 12229 | 0 | 12229 | 0 | 0 | 0 | 0 | 82127 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Project 4 |  |  |  |  | 0 | -57 | 0 | -12 | 0 | 0 | 0 | 1 | 0 |  | 0 |  | 12000 | 227 | 2688 | 228 | 20000 | 15424 | 4480 | 3460 | 8767 | 0 | 1963.808 | 0 | 8767 | 7248 | 1963.808 | 3416 | 1519 | 167 | 341.0155 | 37 | 1352 | 103 | 303.524 | 24 | 1249 | 0 | 280.4005 | 1 | 1249 |  |  | 0 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Project 5 |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 50240.8 | 47382 | 6256.835467980294 | 2689 | 339125.4 | 149772 | 24394.96551724138 | 13480 | 332845.3 | 278017 | 19285.55579439252 | 25022 | 267895.8139534884 | 246088 | 27483.52235294118 | 22147 | 155000 | 153341 | 13950 | 13802 | 84990 | 107916 | 7649.099999999999 | 9712 | 100481.6 | 38455 | 8886.24 | -19954 | 11775 | 40510 | 976.1475 | 19397 | 32611 |  |  |  | 30000 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Project 6 |  |  |  |  | 114398 | 34166 | 22879.6 | -94600 | 150000 | 149374 | 0 | -34527 | 50000 | 52627 | 0 | 5761 | 10000 | -236 | 0 | -134 | 30000 | 12763 | 3270 | 1396 | 30000 | 11770 | 3270 | 1998 | 20280 | 27 | 2230.8 | 3 | 20280 | 0 | 2230.8 | 0 | 20253 | 1 | 2227.83 | 1 | 20280 | 18 | 2224.716 | 3 | 0 |  |  |  | 0 |  |  |  | 40513 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0