Microsoft Excel 2007

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"

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

filledcells in the range that contain London.

Thankyou very much, works perfectly

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

in the same equation?

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)

Thanks again. It works brilliantly. Thank you

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History