Ignoring one value in one column if it is same.

[ms996]

I have two columns,

Sometimes in both column A and B the value is example

example

A = Apples
B = Apples

now I want to use two countif formula, one in column A and column B where if column A has Apples and B has Apples too, it ignores B doesn't add the same thing twice.

I hope I am clear.

How can I do that, please?

[Croweater]

I don't think you are being clear enough to give a definitive answer, with an example workbook showing exactly what you want. (see yellow banner for attaching a workbook).

For example when you say you don't want to add the same thing twice, are you trying to perform a sum of say quantities or prices, or are you adding apples to a list say.

Or do you just want an idication when adding to column B that the product is already in column A. (see attached)

[ms996]

Apologies for that, I kinda figured it

=countif(A:A, "<>Apples", B:B,"Apples"), That ignores the apples from A and only counts the ones in B.

Thus avoiding duplicates.

Let me know if my reasoning is right.

[Croweater]

If it works...your reasoning is right!