Count rows that meet or exceed changeable % and divide by constant number

**acasper3** · 07-23-2012, 10:02 AM

Here's my dilema that I want to create a formula for:
I have a column of percentages, which is actually 77 rows. I want to count each percentage (as a number)that is "at or above" our on track percentage of 22% and divide by 71. I also need this formula for five more columns as well.

My problem is that the 22% number changes weekly. Can I specify a certain cell to pull this number from?
Also, I cannot highlight the entire column for the formula because there are 6 cells that I do not want to include which are subtotal sections. So, I would need to choose certain cells of this column to be included in the formula.

Can a formula be created by choosing certain cells, verifying that they are at or above an on track percentage from another cell, then counting them as a number, and then dividing that number by 71??

I have attached a sample worksheet to work from. Thanks!

**zbor** · 07-23-2012, 10:08 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**zbor** · 07-23-2012, 10:23 AM

Do you mean like this:

**acasper3** · 07-23-2012, 10:27 AM

I need to have the formulas at the bottom of each column. Did you put any formulas in this because I don't see them.

**zbor** · 07-23-2012, 10:28 AM

oh, at the bottom... I've put them on the top (row 3)...

Place it at the bottom:

Formula:

Please Login or Register  to view this content.

**acasper3** · 07-23-2012, 11:09 AM

I copied the formula to the bottom, but it wouldn't work. I want to count the branch percentages as a general number. For instance, I have 71 branches listed, if I have 50 branches over 22% and 21 branches under 22%, I would take the number 50 and divide by 71 to come up with 70% of branches that are over 22%. Is there a way to count multiple sections above or at 22%, add them together and divide by 71 to get a percentage?