Simplify the formula function of SUMIF

[tantcu]

Hi,

my function is try to sum column (AC:AH) but it has to meet certain criteria then I used SUMIFS. This is my formula and hope if you know other formula can simplify this formula.

=SUMIF(INDIRECT("'"&BAT!$C$4&"'!$C$14:$C$10000"),BAT!$E960,INDIRECT("'"&BAT!$C$4&"'!$AC$14:$AC$10000")) + SUMIF(INDIRECT("'"&BAT!$C$4&"'!$C$14:$C$10000"),BAT!$E960,INDIRECT("'"&BAT!$C$4&"'!$AD$14:$AD$10000")) + SUMIF(INDIRECT("'"&BAT!$C$4&"'!$C$14:$C$10000"),BAT!$E960,INDIRECT("'"&BAT!$C$4&"'!$AE$14:$AE$10000"))+ SUMIF(INDIRECT("'"&BAT!$C$4&"'!$C$14:$C$10000"),BAT!$E960,INDIRECT("'"&BAT!$C$4&"'!$AF$14:$AF$10000"))+ SUMIF(INDIRECT("'"&BAT!$C$4&"'!$C$14:$C$10000"),BAT!$E960,INDIRECT("'"&BAT!$C$4&"'!$AG$14:$AG$10000"))+ SUMIF(INDIRECT("'"&BAT!$C$4&"'!$C$14:$C$10000"),BAT!$E960,INDIRECT("'"&BAT!$C$4&"'!$AH$14:$AH$10000"))

Thank you

[Jonmo1]

Try this array formula entered with CTRL + SHIFT + ENTER

=SUM(IF(INDIRECT("'"&BAT!$C$4&"'!$C$14:$C$10000")=BAT!$E960,INDIRECT("'"&BAT!$C$4&"'!$AC$14:$AH$10000")))

[tantcu]

Thank you very much

[Jonmo1]

You're welcome.