Overclock.net › Forums › Software, Programming and Coding › Other Software › Google spreadsheet average calculation?
New Posts  All Forums:Forum Nav:

Google spreadsheet average calculation?

post #1 of 2
Thread Starter 
How would I calculate the average rating of a product? Like newegg's 5 egg rating system.
    
CPUMotherboardGraphicsRAM
Core i7 920 D0 4.2ghz HT MSI x58a-GD45 GTX 980 OCZ XMP 1333 
Hard DriveOSMonitorPower
OCZ Agility Win 7 64 Asus VW266H Corsiar TX850 
MouseMouse PadAudio
Deathadder 3.5 Steelseries Qck Sound Blaster Z 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Core i7 920 D0 4.2ghz HT MSI x58a-GD45 GTX 980 OCZ XMP 1333 
Hard DriveOSMonitorPower
OCZ Agility Win 7 64 Asus VW266H Corsiar TX850 
MouseMouse PadAudio
Deathadder 3.5 Steelseries Qck Sound Blaster Z 
  hide details  
Reply
post #2 of 2
The easiest way (if you wanted say a .5 stepped system) would be to simply fill a column with your values (I'm going to assume you are filling column B). The forumula below will work for infinite rows and give you a rating scale identical to Newegg's.

Place the following formula into whichever cell you'd like, and change the "B's" to whichever column letter corresponds to your correct column. You should probably also format the cell with the formula for a single decimal.

Code:
=MROUND(Average(B1:B),.5)
2600k
(13 items)
 
  
CPUMotherboardGraphicsRAM
2600k @ 4.7 1.38V and climbing ASrock Extreme4 Gen3 GTX 580 DCII 8gb g.skil ripjaws x @1600 
Hard DriveOptical DriveOSMonitor
crucial m4 120 ssd + WD 500 gb Lite-On DVDR-DL Windows 7 x64 Viewsonic vx2268wm 
KeyboardPowerCaseMouse
Microsoft Comfort Curve Seasonic X-750 HAF X Logitech g400 
Mouse Pad
Steelseries QCK+ 
  hide details  
Reply
2600k
(13 items)
 
  
CPUMotherboardGraphicsRAM
2600k @ 4.7 1.38V and climbing ASrock Extreme4 Gen3 GTX 580 DCII 8gb g.skil ripjaws x @1600 
Hard DriveOptical DriveOSMonitor
crucial m4 120 ssd + WD 500 gb Lite-On DVDR-DL Windows 7 x64 Viewsonic vx2268wm 
KeyboardPowerCaseMouse
Microsoft Comfort Curve Seasonic X-750 HAF X Logitech g400 
Mouse Pad
Steelseries QCK+ 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › Google spreadsheet average calculation?