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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!