Item count embeded in calculation formula.

I need a formula that calculates the total cost of travel. We have a column where the traveler can identify how many quarters they need to travel, the number of trips per quarter and the number of travelers per trip, as well as the estimated cost per trip. The calculation would include (# of quarters checked X number of trips per quarter X number of travelers per trip X estimated cost per trip). The countif function counts the cell alone, not the number of items in the cell.

I feel like I'm missing something... but obviously don't know what that is!! TYIA.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!