Formula for multi criteria

[beginvbaanalyst]

Hi Everyone,

I want to check if two fields within my excel data equal the same.
For instance I want to check Column C and Column F have 1011293 with an X.
How would I do that?

 

[beginvbaanalyst]

Using column B as well will serve no purpose if the formula can not recognise the data in column C.

Numbers with a green triangle in the top left corner are formatted as text, those without it are not. Visually identical numbers in the different formats are not countable as the same.

The formula is adding up the count of each of the 3 individual vendor codes where there is an x in column E (although it is actually column F in the picture). With errors and omissions in the description, I had to guess what you wanted.

I don't need it to count up anything.
I'm stuck at trying to have excel understand I want it to exclude these numbers and look for an X when these numbers are present with their specified article.
For example
Article Vendor Regular
1 10011206
1 10011207
1 10011208
1 12345678 X

I want excel to recognize that article 1 has vendors 206, 207, and 208 but 678 is the regular vendor.
Is that helpful?
It's going to be based off article, vendor, and regular vendor relationship.

 

[jasonb75]

You thread title said Countifs, so it was a fair assumption to make.

If you want to count those without x, then you would subtract the formula that I gave you from your existing total.

 

[Fluff]

@beginvbaanalyst
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (rule 12 here: Forum Rules).

I have merged both thread.