# Count Ranking Rounded Up

I need help with creating a formula that rounds the rank of a person up for a tied Count. Situation: “Name 05” has a count of 9. The formula needs to return the first Rank, which would result in 98 (not 100).

Agent: Count: Rank:

Name 01 10 96

Name 02 10 97

Name 03 9 98

Name 04 9 99

Name 05 9 100

Name 06 9 101

Name 07 9 102

The Formula: =SUMPRODUCT(COUNTIF(\$A\$4:\$A\$50,Agent!\$A\$4:\$A153))

“\$A\$4:\$A\$50” is the list of agents I’m looking for, while Agent!\$A\$4:\$A153 returns the rank from the data sheet (which needs to be edited to return the first rank of that count)

By: Justin

### 15 thoughts on “Count Ranking Rounded Up”

1. ig

That is a very good tip particularly to those fresh to the blogosphere.
Simple but very precise info… Many thanks for sharing this one.

2. sling tv

Howdy! Do you use Twitter? I’d like to follow you if that would be ok.
I’m undoubtedly enjoying your blog and look forward

3. sling tv

Hi there, just became aware of your blog through Google, and found that it’s really informative.
I am going to watch out for brussels. I will appreciate if you continue this in future.
A lot of people will be benefited from your writing.
Cheers!

4. match.com free trial

Thanks for one’s marvelous posting! I actually enjoyed reading it, you happen to be a great author.I will make sure to bookmark your blog and may come back at some point.
I want to encourage that you continue your great writing,
have a nice holiday weekend!

5. Typicalcat95

Hi, I do believe this is an excellent blog. I stumbledupon it 😉 I am going to come back yet again since I book-marked it. Money and freedom is the greatest way to change, may you be rich and continue to guide others.

6. coconut oil

Spot on with this write-up, I absolutely believe this amazing site needs a lot more attention. I’ll probably be returning to read more, thanks for the information!

7. ps4 games

I wanted to thank you for this good read!! I absolutely enjoyed every little bit of it.
I’ve got you book marked to look at new stuff you post…

8. quest bars cheap coupon twitter

Howdy this is kinda of off topic but I was wondering if blogs use WYSIWYG editors or if you have to
manually code with HTML. I’m starting a blog soon but have no coding knowledge so
I wanted to get guidance from someone with
experience. Any help would be greatly appreciated!

9. when coconut oil

whoah this blog is excellent i love studying
your articles. Keep up the great work! You already know, a lot of persons are
looking around for this information, you can aid them greatly.

10. tinyurl.com

I really like your blog.. very nice colors & theme. Did you create
this website yourself or did you hire someone to do it for you?
Plz answer back as I’m looking to design my own blog and would like to know where u got this from.
thanks a lot