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.
Answers

You can use the COUNTM Function to count how many values are selected in a multiselect cell!
=COUNTM([FY Quarter]@row) * [# of trips per quarter]@row * [Number of travelers per trip]@row * [Estimated cost per trip]@row
Cheers,
Genevieve
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!