find the formula to calculate only a selection inside a cell which has multiple selections.

David Caron

Hello,

I am trying to find the formula to calculate only a selection inside a cell which has multiple selections.

Example: in a cell, there are 3 selections: blue, yellow and red.

On a 25 row column, I want to know how many "blue" has been selected?

Thank you for helping me!

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAQAAAAngNWGAAAA/0lEQVR4AYXNMSiEcRyA4cfmGHQbCZIipkuxnJgMStlMNmeyD2dwmc8+sZgxYJd9ErIZFHUyYYD7fkr6l4/rnvmtl7+KitrqV/fq2Y5eLY3Z9S48eRLe7BmVZ9qhTLhQ0algzZWQOVKSsCF8OjAnwbxDTWFDUhPK/jMr1H6HE/IqRky2DyvCefuwItwZzodVoYRiLqMkVCXrwpJ9twZ+sgfDYEFYl8wIWxZ9uFf7zkallxlJh4YrLGsKjZRx7VGHhLqwgFUN45DGdb8MeXGpgB4ABZdeDcpZEY51A+hyLKz4S1W4MQWm3AibWtgWmk6dyISa1pSdyWTOlLXVp0+eL9D/ZPfBTNanAAAAAElFTkSuQmCC

Jana Brits

=Countif(range, "blue")

David Caron

Merci @Jana Brits

Avec l'exemple d'un seul mot ça semble fonctionné...

Mais avec nos choix incluant d'autres signes de ponctuation, je n'y arrive pas..

Voici notre sélection à l'intérieur de la cellule. J'aimerais savoir le total individuel de chaque sélection.

• Chili végé (doux) / 25$ (4/5 personnes)
• Mijoté de porc aux carottes / 6,75$ (individuel)
• Poulet chasseur et pommes de terre / 7,25$ (individuel)
• Lasagne à la viande / 27$ (4/5 personnes)

**English translation from Google translate:

Thanks Jana,

With the example of a single word it seems to have worked ...

But with our choices including other punctuation marks, I can't.

Here is our selection inside the cell. I would like to know the individual total of each selection.

Veggie chili (mild) / $ 25 (4/5 people)
Pork stew with carrots / $ 6.75 (individual)
Hunter chicken and potatoes / $ 7.25 (individual)
Meat lasagna / $ 27 (4/5 people)