SUMIF, INDEX, MATCH and Calculate percentage formula
Dana S
✭✭
If a column has a specific value "A&D Fee", I want to go find a column in another sheet "Design Fee", MATCH the Master RE ID numbers and then find 5% of that value. This is the formula I've tried but it does not work. Can anyone offer some suggestions? Thank you.
=SUMIF(Type@row = "A&D Fee", (INDEX({Design Fee}, MATCH([Master RE ID]@row, {TOK RE ID} * 0.05, 0))))))
Answers
-
I normally write that expression as:
=IF(Type@row = "A&D Fee", (SUMIF({Master RE ID}, [Master RE ID]@row, {TOK RE ID}) * 0.05), 0)
Where:
- {Master RE ID} is that column from the Design Sheet
- [Master RE ID]@row points to the row within the sheet that you are doing the calculation
- {TOK RE ID} is the column in the Design Fee sheet where you are storing the number that you need the 5% calculation performed.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!