Microsoft Office Forums - View Single Post - percentage on columns

Thread: percentage on columns

View Single Post

Old

09-01-2010, 09:28 AM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

Default

Assuming you have your times listed in the range A2:A24, and your count of espionage hits in B2:B24.

In cell C2, paste this formula:

Code:

=B2/SUM($B$2:$B$24)

Ensure cell C2 is formatted as "percent", then autofill it down to cell C24.

Cheers,

Reply With Quote