Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-14-2020, 06:55 AM
Bumba Bumba is offline How to calculate average of a ratio from a column? Windows 7 32bit How to calculate average of a ratio from a column? Office 2007
Novice
How to calculate average of a ratio from a column?
 
Join Date: Jan 2019
Posts: 23
Bumba is on a distinguished road
Default How to calculate average of a ratio from a column?

I have worksheet with a column calculating ratio between two decimal numbers. How do I calculate the average of the ratio ?
Attached Files
File Type: xlsx avgratio.xlsx (8.9 KB, 1 views)
Reply With Quote
  #2  
Old 01-14-2020, 09:27 AM
ProudLiberal's Avatar
ProudLiberal ProudLiberal is offline How to calculate average of a ratio from a column? Windows 10 How to calculate average of a ratio from a column? Office 2019
Novice
 
Join Date: Jun 2017
Location: suburban Chicago
Posts: 21
ProudLiberal is on a distinguished road
Default

will this work for you?
Attached Files
File Type: xlsx avgratio.xlsx (10.8 KB, 2 views)
Reply With Quote
  #3  
Old 01-15-2020, 05:53 AM
Bumba Bumba is offline How to calculate average of a ratio from a column? Windows 7 32bit How to calculate average of a ratio from a column? Office 2007
Novice
How to calculate average of a ratio from a column?
 
Join Date: Jan 2019
Posts: 23
Bumba is on a distinguished road
Default

thanks proudliberal ! its working.
Reply With Quote
Reply

Tags
average

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate average of a ratio from a column? Calculate average age (years) lyiio Excel 3 08-13-2017 12:12 AM
How to calculate average of a ratio from a column? how to calculate average time aymanharake Excel 6 02-17-2017 04:22 PM
How to calculate average of a ratio from a column? How to calculate weighted average in table? alexsimpson Word Tables 3 12-01-2016 03:19 PM
dynamic ranges to calculate average teatree Excel 1 11-11-2016 10:11 AM
How to calculate average of a ratio from a column? Calculate average age FTL Excel 1 08-09-2016 06:56 AM


All times are GMT -7. The time now is 02:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft