View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
arash
 
Posts: n/a
Default how can i ignore blank cells when multiple cells?

when i want multiple some celss like
a1*b1*c1*d1
maybe some of this cells are blank
and excel equal that to zero
how can i ignor the zero value (balnk cells ) in multiple

thx