Sumif Help please
I want my totaling cell to add quote on the criteria below.
I have a drop down list in column 1 , in that list I have (con/fine, con/course, con/xtra, ash/fine, ash/course, ash/xtra. grind/fine, grind/course, grind/xtra........this continues for another dozen or so products.
I have m2 rate in column 2, so I enter the data required there.
I have product rate in column 3, so the meter rate (m2) x the product rate give us the cost rate in column 4.
I want the formula to calculate the "product rate" column 3 when ever ash/xtra , con/xtra, grind/xtra.........and the dozen other /xtra are choosen.
When /course or /fine are chosen from any of the drop list I want cost rate column 4 calculated.
Because each product is in a row there will be a mixture of /xtra and /fine /course in the quote. So as long as the totaling cell looks at the correct cells to calculate based on the drop down list. Next question how do you put this together as a formula?
Comments
-
Hi Heath,
I've replied with a possible solution in the other thread that you started about this. Please review that here: https://community.smartsheet.com/discussion/nested-if-statement-0
Let me know if you run into issues with that solution.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives