AVGW Formula for Multiple Cells in One Column

bcg5140

I am trying to apply weights to multiple cells in a "% Completed" column.

My current formula just averages out the values for the selected cells:

=AVG([% Complete]3, [% Complete]5, [% Complete]7, [% Complete]9, [% Complete]11, [% Complete]53)

I'd like to apply weights of 10% to row 3, 5, 7, 9, and 53 with a weight of 50% to row 11. I can't find a way to do this with the AVGW formula that allows me to select only these 6 cells. I tried to use the collect function but kept getting an unparseable error.

VBAGuru

You could try something like:

=Sum([% Complete]3, [% Complete]5, [% Complete]7, [% Complete]9, [% Complete]11*5, [% Complete]53)/10

VBAGuru

You could try something like:

=Sum([% Complete]3, [% Complete]5, [% Complete]7, [% Complete]9, [% Complete]11*5, [% Complete]53)/10

bcg5140

Thanks so much! That worked, simpler than I thought