Coach Hager
New Member
- Joined
- Oct 27, 2008
- Messages
- 27
How do I calculate the weighted average of filtered data? I want it to calculate for any filter in column A.
A B C
1 ITEM UNITS UNIT PRICE
2 TV 10 $100
3 RADIO 5 $20
4 RADIO 10 $15
5 TV 20 $120
When I filter by column A I want the weighted average to show in cell C6. Results should be as follows. When column A is filtered by "TV" weighted average in C6 should show $113.33. When the filter in column A is changed to "RADIO" I want cell c6 (weighted average) to show $16.67
A B C
1 ITEM UNITS UNIT PRICE
2 TV 10 $100
3 RADIO 5 $20
4 RADIO 10 $15
5 TV 20 $120
When I filter by column A I want the weighted average to show in cell C6. Results should be as follows. When column A is filtered by "TV" weighted average in C6 should show $113.33. When the filter in column A is changed to "RADIO" I want cell c6 (weighted average) to show $16.67
Last edited:
