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 2<3 total count 1<2
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.