Averaging with excel
Hello, First-time posting and would like and appeciate some assistance. I have multiple rows that represent the spending for different gyms. I have three columns: one is total gym spending ($), the second is % total gym spending on basketballs, and the third columns is $ of total gym spending spent on basketballs (i.e. column 1: $100, column 2: 10% column 3: $10) I have over 100 gyms listed - how would i calculate the average spend ($) per gym on basketballs. I know I could divide the total spending on basketballs by the number of companies but that would not provide me with a weighted average. Any help??? Thanks everyone, SF -- excelhelp234 ------------------------------------------------------------------------ excelhelp234's Profile: http://www.excelforum.com/member.php...o&userid=26856 View this thread: http://www.excelforum.com/showthread...hreadid=400977 |
Hi
Just average column B =AVERAGE(B1:B100) -- Regards Roger Govier "excelhelp234" wrote in message news:excelhelp234.1uniig_1125529505.0337@excelforu m-nospam.com... Hello, First-time posting and would like and appeciate some assistance. I have multiple rows that represent the spending for different gyms. I have three columns: one is total gym spending ($), the second is % total gym spending on basketballs, and the third columns is $ of total gym spending spent on basketballs (i.e. column 1: $100, column 2: 10% column 3: $10) I have over 100 gyms listed - how would i calculate the average spend ($) per gym on basketballs. I know I could divide the total spending on basketballs by the number of companies but that would not provide me with a weighted average. Any help??? Thanks everyone, SF -- excelhelp234 ------------------------------------------------------------------------ excelhelp234's Profile: http://www.excelforum.com/member.php...o&userid=26856 View this thread: http://www.excelforum.com/showthread...hreadid=400977 |
All times are GMT +1. The time now is 04:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com