Help With SUMIFS Formula

Options

Hello, I'm trying to retrieve SHIPPING COST for the current month of DATE REQUESTED for all repairs under ACTION TAKEN for the WARRANTY ACCOUNT “41130”. There are 4 different columns I’m trying to draw data from and I’m not too sure how to sequence the formula. All caps words are the columns I’m trying to include in the formula. This is what I currently have an am getting #INCORRECT ARGUMENT error.


=SUMIFS({RGA & Service Calls Shipping Costs}, AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())), {RGA & Service Calls Date}, {RGA & Service Calls Action Taken}, [Column2]13, {RGA & Service Calls Warranty Account}, "41130")

Tags:

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    Hi @Zhavion ,

    It looks like your criteria ranges are not quite right and I'm not sure you need the IFERRORs thrown in there as well.

    If Column 2 row 13 has the Action taken criteria you're looking for then I think this is about right (this is one bit I'm not sure on):

    =SUMIFS({RGA & Service Calls Shipping Costs}, {RGA & Service Calls Date}, AND(MONTH(@cell) = MONTH(TODAY()), YEAR(@cell)) = YEAR(TODAY()))), {RGA & Service Calls Action Taken}, [Column2]13, {RGA & Service Calls Warranty Account}, "41130")

    If you have any more details or some screen shots then these would help - if you need to blank out/hide other data then that's fine!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!