Im trying to setup a formula that will add up values of a row of cells IF the dropdown associated with the cell is of a certain value.(ie: Overtime Cells)

If I insert this formula it works fine.
=SUM(IF(J.Adams!$F$4:$F$24=(Summary!$AA$14),(J.Ada ms!$E$4:$E$24)))

The forumla above only adds up one of 10 possible overtime values. now when I try to extend the parameters of the equasion to include all 10 dropdown options as I have below it doesnt work.

=SUM(IF(J.Adams!$F$4:$F$24=(Summary!$AA$14:$AA$23) ,(J.Adams!$E$4:$E$24)))

says "value is not available to the formula or function."
what gives?
I feel like it should work the same with the exception that it is also adding up values if the cells fall under the additional... what am i missing?