Hi all,
I would like to understand what formula I should use in the yellow highlighted cell in order to calculate the % of non-"POTENTIAL OUTLIER" out of the total sum of "count of category" for the respective Origins.
For example, at column Origin = "AT", it will return (20+1)/25 = 84%
I would like to drag down this formula along the column for ease of use and update.
Thank you very much.
excel2.JPG
You could use this and extend the ranges down as far as you need.
Please Login or Register to view this content.
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
This will print on first occurrence of Origin Country:
=IF(COUNTIF($A$2:A2,"=" &A2)=1,((SUMIFS($C$2:$C$8,$A$2:$A$8,"=" &A2,$B$2:$B$8,"<>" & "POTENTIAL OUTLIER")/SUMIF($A$2:$A$8,"=" &A2,$C$2:$C$8))),"")
@JohnTopley That is a nice addition and makes the result look better.
@nigelbloomy : appreciate the feedback
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks