Re: Average function for letters

joeu2004

Guest

Posts: n/a

8th Mar 2012

"ZWarren" <(E-Mail Removed)> wrote:
> I am trying to compute the percentage of the whole
> A4:A24 range where the "X"s will count as a yes
> and the blank field will count as a no, adding up
> all the X's (yes's) and counting them against the
> blank fields (no's) to get an percentage of how
> many X's there are compared to blanks

AVERAGE is the wrong function to use for this purpose. Try:

=COUNTIF(A4:A24,"X")/ROWS(A4:A24)

formatted as Percentage.

Of course, you could replace ROWS(A4:A24) with 21.

« Re: formula | Re: How to lock cell »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: A useful AVERAGE calculation without using the built-in AVERAGE function	קובי	Microsoft Excel New Users	0	3rd Feb 2011 05:25 PM
Re: A useful AVERAGE calculation without using the built-in AVERAGE function	Roger Govier	Microsoft Excel New Users	0	16th Jan 2011 02:20 PM
Error Handling #N/A with AVERAGE Function - Average of values in Row	Sam via OfficeKB.com	Microsoft Excel Worksheet Functions	13	31st Jul 2005 03:59 PM
Why can't you average an average ?	Blewyn	Microsoft Excel Misc	3	12th Nov 2004 03:03 PM
convert =IF(ISERROR(AVERAGE(V10:V13)),"",AVERAGE(V10:V13)) to a function	Niki Odolphi	Microsoft Excel Programming	5	20th Mar 2004 11:11 PM