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

Formual If All Cells are Blank
 

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)

Formual If All Cells are Blank
 

"Linexe" wrote:


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

Formual If All Cells are Blank
 

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

Formual If All Cells are Blank
 

"Linexe" wrote:


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

Formual If All Cells are Blank
 

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