Formula Needed
I need to write a formula that will allow me to parse out a specific number or % (in this case 100%) in a column group of %s and then divide the sum of all those 100%s by the total number of %s such that I get a % of the total number of 100% for that group. IOW, say there are two 100% in my column of 5 total %s...the other three being 45%, 32%, and 3%. I need to show in the cell I place this formula into that there are 2 cells with 100% and then divide that 2 by the total number of cells with %s in them (5 in this case) such that the resultant is 20%. Does that make sense? I'm new to writing formulas in SmartSheet.
Best Answer
-
=SUMIF([Primary Column]2:[Primary Column]7, 1) / COUNTIF([Primary Column]2:[Primary Column]7, [Primary Column]@row)
The problem with smartsheet is that it takes % values as pure numbers. So once you get the value from the formula, you can convert to %.
Hope it helps!!
Answers
-
=SUMIF([Primary Column]2:[Primary Column]7, 1) / COUNTIF([Primary Column]2:[Primary Column]7, [Primary Column]@row)
The problem with smartsheet is that it takes % values as pure numbers. So once you get the value from the formula, you can convert to %.
Hope it helps!!
-
Could you explain what the final entry "...@row" means?
-
NM. I figured it out. Thanks. It worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!