Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > Excel equations

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel equations

Reply to Message Icon

Name: Joel Martyr
Date: October 7, 2009 at 06:57:42 Pacific
OS: OSX 10.4.11
Product: Microsoft Excel 2007
Subcategory: Document Management
Tags: excel equations
Comment:

I'm trying to figure out on excel how to create an
equation that tells me what percentage of filled cells in a
column say "London"



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: October 7, 2009 at 07:05:40 Pacific
Reply:

How about this:

=COUNTIF(A1:A10,"London")/COUNTA(A1:A10)

Format the cell as a precentage.

Keep in mind that COUNTA won't count blank cells in the range, so you are truly getting the percentage of filled cells in the range that contain London.


1

Response Number 2
Name: Joel Martyr
Date: October 7, 2009 at 07:28:52 Pacific
Reply:

Thankyou very much, works perfectly


0

Response Number 3
Name: Joel Martyr
Date: October 7, 2009 at 07:39:12 Pacific
Reply:

If you're still there? How do I include other cells from the sheet
in the same equation?


0

Response Number 4
Name: DerbyDad03
Date: October 7, 2009 at 08:20:19 Pacific
Reply:

In another thread, the OP asked:

I'm trying to add L4:L154 and R4:R154 to the following
equation but I'm not sure how:

=COUNTIF(E4:E154,"London")/COUNTA(E4:E154)

COUNTIF does not support multiple ranges, so you could SUM a number of COUNTIF's:

=SUM(COUNTIF(E4:E154,"London"),COUNTIF(L4:L154,"London"),COUNTIF(R4:R154,"London"))/COUNTA(E4:E154,L4:L154,R4:R154)



1

Response Number 5
Name: Joel Martyr
Date: October 7, 2009 at 08:47:50 Pacific
Reply:

Thanks again. It works brilliantly. Thank you


0

Related Posts

See More



Sponsored Link
Ads by Google
Reply to Message Icon


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links
Ads by Google


Results for: Excel equations
Excel Equation - HELP! www.computing.net/answers/office/excel-equation-help/4065.html

Excel finds to numbers for equation www.computing.net/answers/office/excel-finds-to-numbers-for-equation/7632.html

Excel Formula www.computing.net/answers/office/excel-formula/9579.html