Formula TO NOT have to manully enter formula for every row
Looking for some help on this issue.
We have a sheet with hundreds of rows that tally up to a total (1049.86 hours per below JPEG)
We need to calculate the % each piece is from the total . These are the children rows.
The first formula I got to work by using =SUM([Total Hours Per Peice]42 / ([Total Hours Per Peice]41))
How do I get all the children rows to reference the parent row without having to manually change the formula in every row?
Help Article Resources
Check out the Formula Handbook template!