Posted to microsoft.public.excel.newusers

Geoff

external usenet poster

Posts: 371

How do I calculate a percentage of a column?

I'm using Excel 2002 and have 3 columns. Column B is a series of Y's and N's
(Yes/No). At the bottom of the column, I would like to calculate the
percentage of Y's.

This sheet is a completeness report, so knowing how much work is complete in
percentage would be helpful.
Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculate a productivity percentage	Dyson	New Users to Excel	1	September 13th 07 08:46 AM
How do you calculate a negative percentage	bcurrie	Excel Worksheet Functions	2	July 28th 07 04:31 AM
PIVOT TABLE Custom Column addition to calculate sum and Percentage	[email protected]	Excel Discussion (Misc queries)	0	May 8th 07 11:04 PM
calculate percentage	JP	Excel Worksheet Functions	6	March 2nd 05 02:34 PM
calculate percentage of two cells	Suzie	Excel Worksheet Functions	4	December 3rd 04 05:27 PM

All times are GMT +1. The time now is 02:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us