Formual If All Cells are Blank

  • Thread starter Thread starter Linexe
  • Start date Start date
L

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
 
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)
 
Linexe said:
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)
Click to expand...
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
 
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
 
Linexe said:
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
Click to expand...

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
 
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)
 
Back
Top