Hi nflsales
I've use your formula and...with my file, it's not working. Is that because it's a long file (20.000 rec's)? All data are in the same sheet.
I think my problem is with parentisis.
Can you please check the file attach (livro2.xls). The formula beside Valor should give us 39,92€.
Tks a lot for your time
Best regards