Consolidating Sumif formula

[rhudgins]

Is there a way a to consolidate this formula into something simpler?



=SUMIF('Corporate Actions'!$A$3:$A$1001,'Open Position Report'!C11,'Corporate Actions'!$AE$3:$AE$1001)+SUMIF('Corporate Actions'!$B$3:$B$1001,'Open Position Report'!C11,'Corporate Actions'!$AF$3:$AF$1001)+SUMIF('Corporate Actions'!$C$3:$C$1001,'Open Position Report'!C11,'Corporate Actions'!$AG$3:$AG$1001)+SUMIF('Corporate Actions'!$D$3:$D$1001,'Open Position Report'!C11,'Corporate Actions'!$AH$3:$AH$1001)+SUMIF('Corporate Actions'!$E$3:$E$1001,'Open Position Report'!C11,'Corporate Actions'!$AI$3:$AI$1001)+SUMIF('Corporate Actions'!$F$3:$F$1001,'Open Position Report'!C11,'Corporate Actions'!$AJ$3:$AJ$1001)+SUMIF('Corporate Actions'!$G$3:$G$1001,'Open Position Report'!C11,'Corporate Actions'!$AK$3:$AK$1001)+SUMIF('Corporate Actions'!$H$3:$H$1001,'Open Position Report'!C11,'Corporate Actions'!$AL$3:$AL$1001)+SUMIF('Corporate Actions'!$I$3:$I$1001,'Open Position Report'!C11,'Corporate Actions'!$AM$3:$AM$1001)+SUMIF('Corporate Actions'!$J$3:$J$1001,'Open Position Report'!C11,'Corporate Actions'!$AN$3:$AN$1001)+SUMIF('Corporate Actions'!$BB$3:$BB$1001,'Open Position Report'!C11,'Corporate Actions'!$CF$3:$CF$1001)+SUMIF('Corporate Actions'!$BC$3:$BC$1001,'Open Position Report'!C11,'Corporate Actions'!$CG$3:$CG$1001)+SUMIF('Corporate Actions'!$BD$3:$BD$1001,'Open Position Report'!C11,'Corporate Actions'!$CH$3:$CH$1001)+SUMIF('Corporate Actions'!$BE$3:$BE$1001,'Open Position Report'!C11,'Corporate Actions'!$CI$3:$CI$1001)+SUMIF('Corporate Actions'!$BF$3:$BF$1001,'Open Position Report'!C11,'Corporate Actions'!$CJ$3:$CJ$1001)+SUMIF('Corporate Actions'!$BG$3:$BG$1001,'Open Position Report'!C11,'Corporate Actions'!$CK$3:$CK$1001)+SUMIF('Corporate Actions'!$BH$3:$BH$1001,'Open Position Report'!C11,'Corporate Actions'!$CL$3:$CL$1001)+SUMIF('Corporate Actions'!$BI$3:$BI$1001,'Open Position Report'!C11,'Corporate Actions'!$CM$3:$CM$1001)+SUMIF('Corporate Actions'!$BJ$3:$BJ$1001,'Open Position Report'!C11,'Corporate Actions'!$CN$3:$CN$1001)+SUMIF('Corporate Actions'!$BK$3:$BK$1001,'Open Position Report'!C11,'Corporate Actions'!$CO$3:$CO$1001)

[ConneXionLost]

How about:

=SUMPRODUCT(--('Corporate Actions'!$A$3:$J$1001='Open Position Report'!C11),'Corporate Actions'!$AE$3:$AN$1001)+SUMPRODUCT(--('Corporate Actions'!$BB$3:$BK$1001='Open Position Report'!C11),'Corporate Actions'!$CF$3:$CO$1001)

Cheers,

[rhudgins]

Thanks this works