Forum Discussion
kmarino78
Jun 24, 2022Copper Contributor
Subtotaling Unsorted Data
I have a form that tallies up manhours for construction work. Each type of work is its own categories. there is a subtotal at the bottom adding up all the manhours at the bottom. Issue is some of those manhours are performed by our guys, and some are by subs - even within a single category. I want to have two subtotals dividing up the Company Labor hours with the sub labor hours. I have created a column "Labor Type" that classifies each row as either company labor or sub labor. How can I do this without sorting all of the data by company labor and sub labor? That won't work the way this spreadsheet is setup.
2 Replies
Sort By
- OliverScheurichGold Contributor
- kmarino78Copper ContributorThank you - i was hoping not to use the sum option since in case lines were ever added or deleted but perhaps that is the only way. Thank you -