Issue with function using IF, AND, OR, multiple reference cells and Data Validated list

Hi All,

I have been working on this since weeks now. Tried a lot of experiments but failing over and over again. Details are as follows:

1. I have columns A, B, C, having texts and D, E, having some numeric values. The function is in G.

2. A data validated list in C named "NPD" sourcing list options from L1:L4

3. Function is: If A1 is X, B1 is X1 and C1 is any one from the list NPD then D1+E1 else 0

Seeking Help.

Thanks & Regards
Piyush

Thank You Brumbot. It removed the error but still not getting what I wanted.

Thanks. I have found it through another member's help.

Originally Posted by :) Sixthsense :)

In G1 Cell

Formula:

Please Login or Register  to view this content.

Thank You so much Ms. vlady. It got me what I wanted . Phew was in pain since weeks now.

Originally Posted by vlady

another maybe is

=IF(AND(A1="X",B1="X1",COUNTIF(NPD,C1)=1),D1+E1,0)