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

#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 •