How to count multiple different categories in a single cell.

Occasional Visitor

Hello I have data for example I am shipping orders some orders go out by train truck plane boat some orders go out using one or more method of delivery. I would like to count orders that go by plane and train as well as a combination of other delivery methods. In a table would be great. In one cell.

1 Reply
Use COUNTIFS() function. Attach a sample file with your expected result.