SUMIFS Formula Help

Options
HnDrX
HnDrX
edited 06/06/24 in Formulas and Functions

I'm trying to sum total JAN COST from another sheet if it meets 2 criteria. 1st is that it matches the PF LBC, second is that it matches the 5 CC Code. Sum the total when both criteria match. I've tried a number of formulas and get UNPARSEABLE or INCORRECT ARGUMENT errors.

=SUMIFS({JAN Cost}, {PF LBC}, [PF LBC]@row, {5 CC Code}, [5 CC Code]@row)

All are Text/Number and column headers from both sheets (primary/data) match.

TYIA!

Answers

  • NickStaffordPM
    NickStaffordPM ✭✭✭✭✭
    edited 06/06/24
    Options

    Hey! So I believe the issue if you have the criteria in the formula just pulling from the value that is in that row for that column. You need to fix the selection critera on one cell in particular or include the text you want within " " like the following - "example answer ABC"

    the column@row is the issue I am referring too.

    Let me know if this helps!

    Thanks!

    Nick Stafford

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!