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?

 

[Joe4]

What rows in columns C and F, exactly?
Lets say that you wanted to confirm that C1 equals F1 and C2 equals F2.
You can do that like this:
=IF(AND(C1=F1,C2=F2),"EQUAL","NOT EQUAL")

 

[beginvbaanalyst]

I want to check the entire Columns C if 1011293 has an X value in the entire Column F but they need to match a specific value in Column B.
So lets say column B has 1234 5 times, Column C has 4 different numbers including 1011293 and Column F has an X in the same row as 1011293.
If I need to send a picture I will.
Thank you.

 

[Joe4]

I want to check the entire Columns C if 1011293 has an X value in the entire Column F but they need to match a specific value in Column B.

This makes no sense to me.
How can "1011293 have a value of X in column F"?

 

[beginvbaanalyst]

I'm looking for connections between an article, vendor, and regular vendor combination. I use SAP daily for my job.

 

[Joe4]

I'm looking for connections between an article, vendor, and regular vendor combination. I use SAP daily for my job.

That really does not clarify things at all. Details would be most helpful here. Remember, while you are familiar with the details of your problem, all that we have to go on is what you are sharing with us here in this thread (which has not been very detailed, thus far).

If I need to send a picture I will.

This would probably be very helpful.
You can post images using the tool mentioned here: XL2BB - Excel Range to BBCode

 

[beginvbaanalyst]

Hi Everyone,

It appears my formula isn't working the way I wanted it to.
Here is a photo of my work:

I have a formula where I look for vendors have an X when they are connected to 10011206, 10011207, and 10011208.
I would love a formula that looks for vendors connected to these above ^ but the specific vendor has an X on it.
I have 4 columns based on, Article, Vendor, Regular vendor (has the X in E column), Special Vendor, and Special Vendor Regular.
How do I write a formula that will exclude 10011206, 10011207, and 10011208 but still look for a value on X?
Hoping this is enough information.
Thank you for the help!

 

[jasonb75]

You might be able to do it with

=SUM(COUNTIFS(E:E,"x",C:C,{10011206,10011207,10011208}))

The inconsistent data types in column C could cause problems.

 

[beginvbaanalyst]

You might be able to do it with

=SUM(COUNTIFS(E:E,"x",C:C,{10011206,10011207,10011208}))

The inconsistent data types in column C could cause problems.

I plan to use column B too so it gives a precise reading.
What exactly is this formula doing?

 

[jasonb75]

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.