sum function showing #value

  • Thread starter Thread starter mugen
  • Start date Start date
M

mugen

hi..

have a excel sheet that someone on the group was kind enough to help with.

now got another issue wonder if someone can help

in one column i have a validation drop box selection in another i have an
output based on a vlookup that gives a value based on the option chosen from
the validation dropdown box

for the vloockup i use this syntax
"=IF(ISNA(VLOOKUP(A8,$M$9:$N$27,2,FALSE)),"",IF(VLOOKUP(A8,$M$9:$N$27,2,FALSE)="0","0",VLOOKUP(A8,$M$9:$N$27,2,FALSE)))"
so that no value is shown in box prior selection from drop box.

the sum function sums the value from the vlookup and another cell that is a
numerical value, but is empty till used input. Problem is the cell with the
sum in it shows #value till selected. is there anyway to suppress this till
a selection is made so that blank cell is shown

thanks
 
=IF(ISERR(SUM(A1:A3)),"",SUM(A1:A3))

You can change the contents of the SUM function according to your
needs.
 
Back
Top