An easier way using an array??

[Guest]

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)),............

 

[Guest]

Try this:

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

HTH,
Elkar