Hello Team
I receive multiple worksheets which contain data layouts similar to the following example.
Col A Col B Col C
User UserPercentage Count of GroupNumber
User 1 100.00% 15
User 1 90.24% 1
User 1 Average 16
User 2 100.00% 9
User 2 Average 9
User 3 100.00% 4
User3 Average 4
User4 85.37% 1
User4 98.78% 1
User4 85.37% 1
User4 98.78% 1
User4 Average 4
Grand Total Average 92
What I require is to insert average formulas on each row User Average subtotal row, e.g.m User 1 Average, User 2 Average.
The issue is. referencing the the correct formula cell range for each subtotal row due to the inconsistency of each Users number of entries. For example, to obtain the Average result for User 1, would require to reference B2:B3 (2 cell range), whereas, for User 4, the reference would be F9:F12 (4 cell range).
Can you please advise either how to to identify the correct range appropriate to each user as give above or if there is another more practical way to obtain the same result.
Any advice given will be much appreciated.
Thank you
Sincerely
Dale
Our community of experts have been thoroughly vetted for their expertise and industry experience.