samedi 30 novembre 2019

Adding three cells if a cell has a value, and if it doesn't, adding two

So basically here's what I want to do:

I need to add cells B12 and C12 normally, however -

If cell C3 has a certain text value (let's say "Apples"), I need to add B12, C12, and K3.

But if C3 -isn't- Apples, it should just add B12 and C12.

Additionally, I have two versions of Apples: "Apples - Red" and "Apples - Green". Maybe an Apples wildcard?

Aucun commentaire:

Enregistrer un commentaire