View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Linexe Linexe is offline
external usenet poster
 
Posts: 14
Default Formual If All Cells are Blank



Can anyone give me formual for a sum if all ie (E3:L3) is blank
bearing in mind these cell have both dates and qty in?

I would like: 0

O3=Sum(C3*D3) If E3:L3 = ""

Can anyone help please

Thanks

Linexe