ExcelBanter - An easier way using an array??

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - An easier way using an array?? (https://www.excelbanter.com/excel-worksheet-functions/155510-easier-way-using-array.html)

Tyler

An easier way using an array??

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

Elkar

An easier way using an array??

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

All times are GMT +1. The time now is 01:45 AM.