To check if they're really empty (not even a formula!):

=if(counta(e3:l3)=0,"all empty","not all empty")

So maybe...

In o3:
=if(counta(e3:l3)=0,0,c3*d3)

=sum() doesn't help in this expression: =sum(c3*d3)




Linexe wrote:

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

--

Dave Peterson