Try this:

=SUMPRODUCT(--($L7:$L11+3=AC$5),AC7:AC11)

HTH,
Elkar


"Tyler" wrote:

I am trying to sum the results of an conditional if statement. I know I can
do this with an array rather than usings an If statement for each line but I
am not having any luck. Any help would be appreciated. Thanks
=SUM(IF($L7+3=AC$5,AC7,0),IF($L8+3=AC$5,AC8,0),IF( $L9+3=AC$5,AC9,0),IF($L10+3=AC$5,AC10,0),IF($L11+3 =AC$5,AC11,0)),............