| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)),............ |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)),............ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| easier way to do this? | Excel Discussion (Misc queries) | |||
| got to be an easier way? | Excel Discussion (Misc queries) | |||
| There's Got to be an Easier Way | Excel Discussion (Misc queries) | |||
| Is there an easier way? | Excel Discussion (Misc queries) | |||
| Easier Way? | Excel Worksheet Functions | |||
Hybrid Mode
