calculation question

Options


I am looking for a way to parse column Task/Description and add up all of the items sub totals.

Ideally should look like this:

400- Sorter & Recirc Loop 416

500- 3 Aftersorts 144

There will be other tasks/descriptions, Tasks 100 to 1000. We just haven't gotten that far yet


Any assistance would be appreciated.

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi

    It sounds like you want to sum the subtotals for each Task/Description separately.

    The SUMIF formula will do this.

    The syntax is SUMIF(range, criterion, sum_range)

    So, if your data looks like this

    You can create this

    Using this formula in Column6

    =SUMIF([Task/Description]:[Task/Description], [Column5]@row, [Sub Total]:[Sub Total])

    This means sum all the amounts in the [Sub Total] column where the value in the [Task/Description] column matches the value in [Column5] on this row.

    You probably want to do this in a separate sheet, in which case you will need to change the column references to cross-sheet references. Explanation here if you need it: https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!