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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!