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
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions

Thank you @Genevieve P.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!