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