Count ifs problem

[geliedee]

Hi All,

Can someone help me with count ifs?

You can see in column A is the customer
Column B - is the company code

Column E & F are the extracted data

Column I is the output.

So here's the condtion:

1. If the customer exist in one company code (based on column E & F), then it should be blank.
2. If the customer exist in 2 company code (based on column E & F), then it should be "Co.Code Delete"

Can anyone help?
Im using this formula but it doesnt seem work.

Please Login or Register  to view this content.

[samba_ravi]

=IF(COUNTIFS(E:E,A2,F:F,B2),"Co.Code Delete","")

Please Login or Register  to view this content.

TRY THIS

[Richard Buttrey]

Hi,

Your explanation is unclear, at least to me. Please add a few more example rows that show different permutations, manually add the results and the clearly explain why you arrive at the results you do.

[geliedee]

Hi Richard,

Thanks for your reply.

Please see below for the detailed explanation.

I have customer number (column A) and company code (Column B) which will be removed in the system im working on.
Inorder to determine if it will be deleted or not, here's the condition.

1. If customer exist only in one company code given (column b) and the same as the extracted data (column E and F) then the results should be blank.



2. If the customer exist in 2 company codes and there's no "X" sign in Column G (meaning its still active), then the results should be "Co.Code Delete".

3. If the customer exist in multiple company code but is only active in the given company code (column b) then its should be blank.

I added some conditions just to make it clearer..
Thanks in advance..

[geliedee]

Hi nflsales,

Thanks for your reply..
The formula you gave "Co.Code Delete" as the result for all

[jason.b75]

Try

=IF(COUNTIFS(E:E,A2,G:G,"<>x")>1,"Co code. Delete","")