SUMIFS with 2 criteria

grussell24246

Can't get the right formula for the task I want to perform - as follows -

IF the PRODUCT column = "MMS", and the POSITION column = "CURRENT - CORE", then SUM the JAN'18 FCAST column basEd on the following range - JAN'18 facst19:JAN'18 fcast160

Latest formula version I tried is:

=SUMIFS(JAN'18 fcast19:JAN'18 fcast160, $PRODUCT19:$PRODUCT160, "Core: MMS", [$POSITION19:$POSITION160, "CURRENT - CORE"])

rjudenberg

=SUMIFS([JAN'18 fcast]19:[JAN'18 fcast]160, PRODUCT19:PRODUCT160, "Core: MMS", POSITION19:POSITION160, "CURRENT - CORE")