"reznor9" wrote:
Now I have another example that will hopefully put it
into better perspective as to what Im attempting to do.
=SUM(IF(J.Gutierrez!$F$4:$F$24=(Summary!$AA$14),(J .Gutierrez!$E$4:$E$24)))
+
SUM(IF(J.Gutierrez!$F$4:$F$24=(Summary!$AA$15),(J. Gutierrez!$E$4:$E$24)))
+
[....]
+
SUM(IF(J.Gutierrez!$F$4:$F$24=(Summary!$AA$23),(J. Gutierrez!$E$4:$E$24)))

Does the following array-entered formula do what want (press
ctrl+shift+Enter instead of just Enter)?

=SUM(IF(J.Gutierrez!F4:F24=TRANSPOSE(Summary!AA14: AA23),J.Gutierrez!E4:E24))

-----

To understand how the formula works, try the following demonstration in a
new workbook.

Enter a into A1, b into A2 and c into A3. Copy A1:A3 and paste into A4:A9.
The result should be a, b and c repeated 3 times.

Enter 1 into B1, and enter =10*B1 into B2. Copy B2 and paste into B3:B9.
Format B1:B9 as Number with 0 decimal places. Better: format as Custom
000000000.