Calculate total cost based on department selection
I want to calculate the total price based on the department selection, in this case if select "PO" as department its should take the Handling fee SBS, and other department it should take handling fee others
=SUMIFS([Cost Price]@row * [Total Quantity Requested ]@row + [Handling Fee SBS]@row, Department@row, "PO", Collected@row, 1)
Answers
-
@Genevieve P. @Paul Newcome any workaround to calculate based on the selection?
FYI. I have item master in other sheet where I maintain the pricing. Please help me with the formula to calculate based on the department selection
-
You would need to do some of the calculations on the row before using the SUMIFS function. For example, this would be in your Total Price column:
=([Cost Price]@row * [Total Quantity Requested ]@row) + [Handling Fee SBS]@row
Then since you have a total price in each row, you can SUM that total column based on your criteria:
=SUMIFS([Total Price]:[Total Price], Department:Department, "PO", Collected:Collected, 1)
Let me know if that makes sense and will work for you!
Cheers,
Genevieve
-
Thank you @Genevieve P.
Help Article Resources
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
Check out the Formula Handbook template!