Spreadsheet: 724862d1616425126-if-statement-sum-with-multiple-criteria-book2
Sheet: Atth4 Team

# | Company Name | Company's Position for this effort: Prime, Team Member, or Subcontractor | IT Sch | [NAME]: | [NAME] |  |  |  | Task Order/Project Leader | Principal Engineer/Scientist | Senior Engineer/Scientist | Engineer/Scientist | Journeyman Engineer/Scientist | Entry Level Engineer/Scientist | Co-Op Engineer/Scientist | Senior Technical Specialist | Technical Specialist | Senior Analyst/Log/Specialist | Journeyman Analyst/Log/Specialist | Entry Level Analyst/Log/Specialist | Senior Programmer | [NAME] | Administrative Support | Subject Matter Expert
1 | Company 1 | Prime |  | GS-XX-1 | MAS |  |  | =IF($C6="Prime",SUM(IF('TM_Pricing Roll Up'!$B$13:$B$590=$B6,IF(LEFT('TM_Pricing Roll Up'!$C$13:$C$590,12)=LEFT($E$6,12),IF('TM_Pricing Roll Up'!$BO$13:$BO$590=I$5,'TM_Pricing Roll Up'!$BC$13:$BC$590,0)))))+IF(AND($C6="Prime",$D6="IT"),SUM(IF('TM_Pricing Roll Up'!$B$13:$B$590=$B6,IF(LEFT('TM_Pricing Roll Up'!$C$13:$C$590,12)=LEFT($E$7,12),IF('TM_Pricing Roll Up'!$BO$13:$BO$590=I$5,'TM_Pricing Roll Up'!$BC$13:$BC$590,0)))))+IF($C6="TM",SUM(IF('TM_Pricing Roll Up'!$B$13:$B$590=$B6,IF(LEFT('TM_Pricing Roll Up'!$C$13:$C$590,12)=LEFT($E6,12),IF('TM_Pricing Roll Up'!$BO$13:$BO$590=I$5,'TM_Pricing Roll Up'!$BC$13:$BC$590,0)))))+IF(AND($C6="SC",$D6="IT"),SUM(IF('TM_Pricing Roll Up'!$B$13:$B$590=$B6,IF(LEFT('TM_Pricing Roll Up'!$C$13:$C$590,12)=LEFT($E$7,12),IF('TM_Pricing Roll Up'!$BO$13:$BO$590=I$5,'TM_Pricing Roll Up'!$BC$13:$BC$590,0)))))+IF($C6="SC",SUM(IF('TM_Pricing Roll Up'!$B$13:$B$590=$B6,IF(LEFT('TM_Pricing Roll Up'!$C$13:$C$590,12)=LEFT($E$6,12),IF('TM_Pricing Roll Up'!$BO$13:$BO$590=I$5,'TM_Pricing Roll Up'!$BC$13:$BC$590,0)))))
2 | Company 1 | Prime | IT | GS-XX-2 | MAS (IT)
3 | Company 2 | TM |  | GS-XX-3 | MAS
4 | Company 3 |  |  | GS-XX-4 | MAS
5 | Company 4 |  |  | GS-XX-5 | MAS
6 | Company 5 |  |  | GS-XX-6 | MAS
7 | Company 6 |  |  | GS-XX-7 | MAS
8 | Company 7 |  |  | GS-XX-8 | MAS
9 | Company 8 |  |  | GS-XX-9 | MAS
10 | Company 9 |  |  | GS-XX-10 | MAS
11 | Company 10 |  |  | GS-XX-11 | MAS
12 | Company 11 | SC |  | GS-XX-12 | MAS
13 | Company 12 |  |  | GS-XX-13 | MAS
14 | Company 13 | TM |  | GS-XX-14 | MAS
15 | Company 14 | SC |  | GS-XX-15 | MAS
16 | Company 15 |  |  | GS-XX-16 | MAS
17 | Company 16 |  |  | GS-XX-17 | MAS
18 | Company 17 |  |  | GS-XX-18 | MAS
19 | Company 18 |  |  | GS-XX-19 | MAS
20 | Company 19 |  |  | GS-XX-20 | MAS
21 | Company 20 |  |  | GS-XX-21 | MAS
22 | Company 21 |  |  | GS-XX-22 | MAS
23 | Company 22 |  |  | GS-XX-23 | MAS
24 | Company 23 |  |  | GS-XX-24 | MAS
25 | Company 24 |  |  | GS-XX-25 | MAS
26 | Company 25 |  |  | GS-XX-26 | MAS
27 | Company 26 |  |  | GS-XX-27 | MAS
28 | Company 27 |  |  | GS-XX-28 | MAS
29 | Company 28 | TM |  | GS-XX-29 | MAS
30 | Company 29 |  |  | GS-XX-30 | MAS
31 | Company 30 |  |  | GS-XX-31 | MAS
32 | Company 31 |  |  | GS-XX-32 | MAS
33 | Company 32 | TM |  | GS-XX-33 | MAS
34 | Company 33 | TM |  | GS-XX-34 | MAS
35 | Company 34 | TM |  | GS-XX-35 | MAS
36 | Company 35 |  |  | GS-XX-36 | MAS
37 | Company 36 |  |  | GS-XX-37 | MAS
38 | Company 37 |  |  | GS-XX-38 | MAS
39 | Company 38 |  |  | GS-XX-39 | MAS
40 | Company 39 |  |  | GS-XX-40 | MAS (IT)
41 | Company 40 |  |  | GS-XX-41 | MAS
42 | Company 41 |  |  | GS-XX-42 | MAS (IT)
43 | Company 42 |  |  | GS-XX-43 | MAS
44 | Company 43 | TM |  | GS-XX-44 | MAS
45 | Company 44 |  |  | GS-XX-45 | MAS
46 | Company 45 |  |  | GS-XX-46 | MAS
47 | Company 46 |  |  | GS-XX-47 | MAS
48 | Company 47 |  |  | GS-XX-48 | MAS
49 | Company 48 |  |  | GS-XX-49 | MAS
50 | Company 49 |  |  | GS-XX-50 | MAS
51 | Company 50 |  |  | GS-XX-51 | MAS
52 | Company 51 | TM |  | GS-XX-52 | MAS
53 | Company 52 |  |  | GS-XX-53 | MAS (IT)
54 | Company 53 |  |  | GS-XX-54 | MAS
55 | Company 54 |  |  | GS-XX-55 | MAS
56 | Company 55 |  |  | GS-XX-56 | MAS
57 | Company 56 |  |  | GS-XX-57 | MAS
58 | Company 57 | TM |  | GS-XX-58 | MAS
59 | Company 58 |  |  | GS-XX-59 | MAS
60 | Company 59 | TM |  | GS-XX-60 | MAS
61 | Company 60 | TM |  | GS-XX-61 | MAS
62 | Company 61 | TM |  | GS-XX-62 | MAS
63 | Company 62 | TM |  | GS-XX-63 | MAS
64 | Company 63 |  |  | GS-XX-64 | MAS
65 | Company 64 |  |  | GS-XX-65 | MAS
66 | Company 65 |  |  | GS-XX-66 | MAS
67 | Company 66 |  |  | GS-XX-67 | MAS
68 | Company 67 |  |  | GS-XX-68 | MAS
69 | Company 68 |  |  | GS-XX-69 | MAS
70 | Company 69 |  |  | GS-XX-70 | MAS
71 | Company 70 | TM |  | GS-XX-71 | MAS
72 | Company 71 | TM |  | GS-XX-72 | MAS
73 | Company 72 |  |  | GS-XX-73 | MAS
74 | Company 73 |  |  | GS-XX-74 | MAS
75 | Company 74 |  |  | GS-XX-75 | MAS
76 | Company 75 | TM |  | GS-XX-76 | MAS
77 | Company 76 |  |  | GS-XX-77 | MAS
78 | Company 77 |  |  | GS-XX-78 | MAS
79 | Company 78 |  |  | GS-XX-79 | MAS
80 | Company 79 |  |  | GS-XX-80 | MAS
81 | Company 80 | SC |  | GS-XX-81 | MAS
82 | Company 81 | TM |  | GS-XX-82 | MAS
83 | Company 82 |  |  | GS-XX-83 | MAS
84 | Company 83 | TM |  | GS-XX-84 | MAS
85 | Company 84 |  |  | GS-XX-85 | MAS
86 | Company 85 | TM |  | GS-XX-86 | MAS
87 | Company 86 |  |  | GS-XX-87 | MAS
88 | Company 87 |  |  | GS-XX-88 | MAS
89 | Company 88 |  |  | GS-XX-89 | MAS
90 | Company 89 |  |  | GS-XX-90 | MAS
91 | Company 90 |  |  | GS-XX-91 | MAS
92 | Company 91 |  |  | GS-XX-92 | MAS
93 | Company 92 |  |  | GS-XX-93 | MAS
94 | Company 93 |  |  | GS-XX-94 | MAS
95 | Company 94 |  |  | GS-XX-95 | MAS (IT)
96 | Company 95 |  |  | GS-XX-96 | MAS
97 | Company 96 |  |  | GS-XX-97 | MAS
98 | Company 97 |  |  | GS-XX-98 | MAS
99 | Company 98 |  |  | GS-XX-99 | MAS
100 | Company 99 | TM |  | GS-XX-100 | MAS
101 | Company 100 |  |  | GS-XX-101 | MAS
102 | Company 101 | TM |  | GS-XX-102 | MAS
103 | Company 102 |  |  | GS-XX-103 | MAS
104 | Company 103 |  |  | GS-XX-104 | MAS
105 | Company 104 |  |  | GS-XX-105 | MAS
106 | Company 105 |  |  | GS-XX-106 | MAS
107 | Company 106 |  |  | GS-XX-107 | MAS
108 | Company 107 |  |  | GS-XX-108 | MAS
109 | Company 108 |  |  | GS-XX-109 | MAS
110 | Company 109 |  |  | GS-XX-110 | MAS
111 | Company 110 | SC |  | GS-XX-111 | MAS
112 | Company 111 |  |  | GS-XX-112 | MAS
113 | Company 112 |  |  | GS-XX-113 | MAS
114 | Company 113 |  |  | GS-XX-114 | MAS
115 | Company 114 | TM |  | GS-XX-115 | MAS
116 | Company 115 |  |  | GS-XX-116 | MAS
117 | Company 116 |  |  | GS-XX-117 | MAS
118 | Company 117 |  |  | GS-XX-118 | MAS
119 | Company 118 |  |  | GS-XX-119 | MAS
120 | Company 119 | TM |  | GS-XX-120 | MAS
121 | Company 120 | SC
122 | Company 120 | SC | IT
123 | Company 121 | SC
124 | Company 122 | SC
125 | Company 122 | SC | IT
126 | Company 123 | SC
127 | Company 124 | SC
128 | Company 125 | SC
129 | Company 126 | SC
130 | Company 126 | SC | IT
131 | Company 127 | SC
132 | Company 128 | SC
133 | Company 129 | SC
134 | Company 130 | SC
135 | Company 131 | SC