Excel equations

Microsoft Excel 2007
October 7, 2009 at 06:57:42
Specs: OSX 10.4.11
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"

See More: Excel equations

Report •


#1
October 7, 2009 at 07:05:40
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.


Report •

#2
October 7, 2009 at 07:28:52
Thankyou very much, works perfectly

Report •

#3
October 7, 2009 at 07:39:12
If you're still there? How do I include other cells from the sheet
in the same equation?

Report •

Related Solutions

#4
October 7, 2009 at 08:20:19
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)



Report •

#5
October 7, 2009 at 08:47:50
Thanks again. It works brilliantly. Thank you

Report •


Ask Question