calculation question
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

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 crosssheet references. Explanation here if you need it: https://help.smartsheet.com/articles/2482644createcrosssheetreferences
Answers

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 crosssheet references. Explanation here if you need it: https://help.smartsheet.com/articles/2482644createcrosssheetreferences

Thank you! worked perfect!

pleased I could help!
Help Article Resources
Categories
Check out the Formula Handbook template!