Hello!
I have the formula:
if(or(sum(Quant.)=0;sum(price)=0);0;vlookup(sum(Qu ant.);L26:M29;2))
but is not that result that i want
Quant. and price are names for cells groups
Quant. = A16:A37
Price = H16:H37
I want that the the result of the formula just change when the cell of
quant. and the cell of price in the same row is whit a value

thank you
Helena Carona

--
HC