Elaine -

You are assuming that your posts explain your questions, when they don't.

You are showing 3 columns of numbers per 'group' but don't indicate which of
the columns should be averaged, and your comments about how they should be
weighted make little sense to me.

Total weighted score for the group?

It seems as though it'll be easy to offer you a solution, if you can simply
AND COMPLETELY state what you need to accomplish, what the inputs are and
what the mean. Without that info, we're left to guess.

"elaine9412" wrote:

one more thing I want to exclude zeros

"Duke Carey" wrote:

Which column of values gets averaged? 1st? 2nd? 3rd? or some combination?

Your answer also leads to another question. Simply multiplying the average
for group 1 by 3 will do what you want, but by itself it means nothing. Do
you want the weighted average of the 2 groups, given the weights you've just
described? In that case it is =(3*average(group1)+2*average(group2))/5

"elaine9412" wrote:

I want the average of group 1 and give it a weighting of 3. I want the
average of group 2 and give it a weighting of 2.

"elaine9412" wrote:

Thanks for my previous help. Now I have the data and I need to do a weighted
average for different groups of data as follows:

group 1:
Total count 3 total count 23 total count 12
12 9 5
2 7 3
5 8 1

Group 2 has same heading as above but more rows of data:
2 7 1
3 6 1
2 3 1
6 5 1
6 5 1


I have 8 separate groups.

Once again appreciate your help.