I have one more problem...I use this vlookup formula in B cells
=IF(A2<"",VLOOKUP($A2,$J$1:K51,2,FALSE),"") to extract some prices...

A B
1 01254 #N/A
2 total i.s. 12 3.65
3 total i.s. 15 2.86
4 02458 #N/A

I don't want to see #N/A ....I don't want anything to apear in B1, B4....
How can i do this??

Thanks again! My best regards
puiuluipui

"puiuluipui" wrote:

Thanks! works great...Thanks again!

"Ron Coderre" wrote:

I'm not sure where the SUMIF come in, but from what you posted, try something
like this:

For values in C1 and D1
E1: =C1*D1

Or to NOT display zero values
E1: =IF(COUNT(C1:D1)=2,C1*D1,"")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"puiuluipui" wrote:

i need to make this work =sum(c4*d4), but i have some cells that does not
contain anything and the result looks like that #VALUE!

1 c d e(sum)
2
3 3 5 15
4 2 #VALUE!


I don't want anything to apear in e4, or in the worst case i want 0 to apear
in this cell.
Anyone can help me? Thanks