SUMIFS with 2 criteria

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"])

Screen Shot 2018-01-19 at 11.09.07.png

Find more posts tagged with

Formulas

Comments

rjudenberg

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

Sign in to join the conversation!

Quick Links

Trending discussions

seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…