I think this might be a simple problem, but I'm very limited in my Excel skills.
In the attached sample, I'm trying to get a percentage for the Class C IP's used. So, I have a total of 24 links. Many of them share the same Class C IP. I need to get the percentages.
Not sure if I should use a SUMIF or another function.
All help appreciated.
Thanks
Last edited by newbieexceldude; 10-19-2011 at 08:06 PM.
By the way, here is attachment for the desired output.
Any ideas, guys?
Hello newbieexceldude,
How are you determining your percentages? I can not replicate the numbers you provided in the sample workbooks.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Leith,
Those aren't real numbers, just an example of what the final output should be
Looks like I might have to do this the long way
I think the issue is that we don't really understand what you're trying to do. When you say the percentage of class C IPs used is what you're after counting how many unique class C addresses appear in your list?
If so you can do this in your original sample file using the array formula =SUM(IF(E2:E25<>E1:E24,1,0))
Because it's an array you must use Ctrl-Shift-Enter to enter it into the cell, not just enter by itself.
I see Andrew. I apologize for the confusion. Yes, it's pretty much what you said -- calculate how many unique class C addresses appear in my list (as an overall percentage of all Class C IPs)
I guess basically, I want to know what percentage each Class C IP contributes to the whole.
So if I have 25 cells, and a Class C IP appears in 5 out of 25, I want the formula to return the value of 25%
Does that make more sense?
I'm thinking now, that this would work better with just a summary table that just outputs 1 (unique) Class C IP and the corresponding percentage
Last edited by newbieexceldude; 10-17-2011 at 08:53 PM.
How about the attached? This is your original sample sheet with a simple summary page.
I've used a helper column (column G on the original sheet), because it keeps the formula a lot simpler.
That's Perfect, Andrew. Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks