Calculating a sum

Options

Hello, I am hoping someone can help me figure out a way to do this formula. The following formula works:

=SUMIF(Part@row, "022-7374-00", [PO Price]@row * [Bal Due]@row)

I'd like to replace the "022-7374-00" with a whole column of part numbers on another sheet. If the Part@row matches any of the numbers in my SL Tab column on another sheet, I want it to do the sum. When I replace "022-7374-00" with the column name, I get 0 in columns I know the part number is listed on the SL Tab. Here is that formula. What am I doing wrong?

=SUMIF(Part@row, {SL Tab}, [PO Price]@row * [Bal Due]@row)

Answers

  • jmyzk_cloudsmart_jp
    jmyzk_cloudsmart_jp ✭✭✭✭✭✭
    Options

    Hi @BFuller

    I would add a helper column to calculate [PO Price]@row * [Bal Due]@row, then reference the column range in the SUMIF function.😀

    The syntax of the SUMIF function is as follows:

    SUMIF( range, criterion, [ sum_range ])

    So, the formula should look like this:

    =SUMIF({SL Tab}, Part@row, {helper column range})

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!