Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 22

Getting a percentage

I have several columns with 1 of 4 values (Y,N,N/A,<blank). I need to
calculate the percentages of Y's. For example if there are 6 columns, 3 with
Y's, 2 with N's and one with N/A, I need for my totals column to report 50%.
What is the best way to do this?
--
Enrique

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
Add a percentage	slavenp	Excel Discussion (Misc queries)	2	December 18th 07 01:29 PM
percentage	formula101	Excel Worksheet Functions	2	November 5th 07 04:28 AM
percentage	cj	Excel Discussion (Misc queries)	6	October 28th 07 01:40 AM
Calculating a percentage with the end percentage in mind	Shadowshady	Excel Discussion (Misc queries)	2	June 17th 06 09:41 AM
Bar Chart depicting the "percentage of another percentage(less than 100)"	TEAM	Charts and Charting in Excel	1	October 28th 05 05:06 AM

All times are GMT +1. The time now is 08:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us