Forum Discussion

Johndoe980's avatar
Johndoe980
Copper Contributor
Oct 17, 2022

How to count multiple different categories in a single cell.

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

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Use COUNTIFS() function. Attach a sample file with your expected result.

Resources