PC Review


Reply
Thread Tools Rate Thread

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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


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