Formual If All Cells are Blank

[Linexe]

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

 

[Linexe]

Sorry, I meant to say, I am getting as far as this, burit doesn't seem
to work, any ideas?


=IF((E3,G3,I3,K3<0)+IF(F3,H3,J3,L3=""),C3*D3)

 

[Ceptor55]

Sorry, I meant to say, I am getting as far as this, burit doesn't seem
to work, any ideas?


=IF((E3,G3,I3,K3<0)+IF(F3,H3,J3,L3=""),C3*D3)

What specifically are you trying to achieve?

Do you want the cell to equal '0' if all of the cells E3,G3,I3,K3 and
F3,H3,J3,L3 are all blank??

If so try,

=if(AND(E3=0,G3=0,I3=0,K3=0,F3=0,H3=0,J3=0,L3=0),"",C3*D3)

Not sure what C3 and D3 are however from your formula I assume that if any
of the cells E3 onwards are not equal to '0' then you want the result to me
C3 and D£ multiplied

 

[Linexe]

Nearly.......

=IF(AND(E3="",G3="",I3="",K3="",F3="",H3="",J3="",L3=""),"",C3*D3)

This gives me the sum of E3:L3 which has Text/qty in,

I need to know what O3 is if All the cell E3:L3 are blank


Thank you in advance

 

[Ceptor55]

Nearly.......

=IF(AND(E3="",G3="",I3="",K3="",F3="",H3="",J3="",L3=""),"",C3*D3)

This gives me the sum of E3:L3 which has Text/qty in,

I need to know what O3 is if All the cell E3:L3 are blank


Thank you in advance

Think I might be missing something, however if as you say all you are after
is the value of O3 if E3:L3 are blank then all you need is

=IF(AND(E3="",G3="",I3="",K3="",F3="",H3="",J3="",L3=""),O3,C3*D3)

this will result in the value of C3*D3 if any of the cells are not bblank

If this isn't it then feel free to email a section of the spreadsheet with
an outline of what you want from each cell and i'll be happy to sort ot for
you

 

[Dave Peterson]

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)