Spreadsheet: 120077d1314965833-lookup-formula-that-evaluates-two-criteria-book2
Sheet: monthly data

 | AA | AJ | BA | CC | EX | FA | GG | GP | IT | LX | MK | NE | OP | PA | PH | SA | TA | UB | VA | Co-ops | Total
Projects Total
General Projects
Project number one
Project number one A | 12.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.046875 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
Project number one B | 0 | 0 | 43.373443 | 0 | 0 | 0 | 0 | 0 | 0 | -1.110223024625157e-16 | 0 | 0 | 0 | 0 | 0 | 0 | 0.9359400000000001 | 0 | 0 | 0
Project number one C | 0 | 4.757813000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Project number one D | 0.204688 | 0.242188 | 0.7921879999999999 | 0.145314 | 30.029698 | 0 | 0.571878 | 0 | 1.11719 | 1.051563 | 0.120313 | 4.596882 | 1.462501 | 18.00000300000001 | 1 | 0.7250030000000002 | 2.118754 | 0.359375 | 0.364063 | 0
Project number one E | 0 | 0.5 | 0 | 14.185942 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Project number one F | 0 | 0 | 0 | 0 | 0 | 0 | 67.86880400000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Project number one G | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31.059407 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Project number one Sub 1
Project number one Sub 1 A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 44.892197
Project number one Sub 1 b | 15.7 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3.609378 | 0 | 0 | 29.764068 | 0.55 | 0 | 0 | 0.189063 | 27.820319 | 0.064063 | 0 | 0
Project number one Sub 1 C | 0 | 0 | 0 | 0 | 0 | 0 | 1.828127 | 0 | 2 | 0 | 0 | 0 | 5.825002 | 0 | 0 | 1.220313 | 0.309375 | 0 | 0 | 0
Project number one Sub 2
Project number one Sub 2 A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.048438 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Project number one Sub 2 B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.078126 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Project number one Sub 2 C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3.006251 | 0 | 0 | 0
Project number one Sub 3
Project number one Sub 3 A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.164063 | 0 | 9.465628 | 0 | 0 | 0
Project number one Sub 3 B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0
Project number two | 0 | 0 | 0 | 0 | 0 | 0 | 0.367188 | 0 | 0 | 0 | 0 | 1.395313 | 1.182815 | 0 | 0 | 0 | 21.142192 | 0 | 0 | 0
Project number three
Project number three A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9.900001 | 0 | 0 | 0
Project number three B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.5875 | 0 | 0 | 0
Project number three C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.5125 | 0 | 0 | 0
Project number three D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5.000001 | 0 | 0 | 0
Project number four | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17.220314 | 0 | 0 | 0 | 0
Project number five | 1.70625 | 0 | 0 | 0 | 0 | 0 | 1.367188 | 0 | 1 | 0 | 0 | 0.0375 | 12.275008 | 0 | 0.171875 | 0 | 69.12347600000001 | 0.276563 | 0 | 0
Project number six
Project number six A | 0 | 0 | 0 | 0 | 0.317188 | 0 | 0 | 0 | 91.721898 | 0 | 0.5 | 0.04375300000000004 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
Specific Projects
Project number seven | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 79.965638 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Project number eight
Project number eight A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4.262502 | 0 | 0 | 0 | 0 | 0.06406300000000001 | 0 | 0 | 0
Project number eight B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Project number eight C | 9.356251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4.303126 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Project number nine
Project number nine A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23.631252 | 0 | 0 | 0 | 0
Project number nine B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24.878134 | 0 | 0 | 0 | 0
Project number ten | 0 | 0 | 0 | 0 | 0 | -2.775557561562891e-17 | 0 | 0 | 0.8453139999999999 | 0 | 0 | 34.47189900000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0