I have a conflict here, I want to calculate the percentage of hiring as shown, but the input given to me is per row as shown in the completion % column..but I wanted to be weighted by the number of hiring as I don't think that hiring 1 person is as hiring 15!
so I added a helper column called Number of H&T and inserted the number then make an equation for the sum as shown in the brown row then for another added column (Count percentage) I make equation (=[Completion %]@row / [Number of H&T]$39) and at the brown row make =AVG([Count precentage]40:[Count precentage]45), I feel that is a long loop and don't know if that is correct or not, then I have to calculate all hiring for the operation which are separate in a different row hence I want to calculate at the sheet summary ..which equation I should use also?
thanks in advance
Help Article Resources
Check out the Formula Handbook template!