Forum Discussion

kmarino78's avatar
kmarino78
Copper Contributor
Jun 24, 2022

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

    • kmarino78's avatar
      kmarino78
      Copper Contributor
      Thank 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 -

Resources