Need formula to sum if not blank

[daniels012]

I want to do this formula

=vlookup(1,W2:Y5,3,false)

but only when every cell in I14:I19 are greater than "" (not empty)

How can I do this with a formula?


Thank You,
Michael

 

[Joe4]

What kind of values are in I14:I19?
Alpha or numeric?
Is zero a valid number that might show up?

 

[daniels012]

They will be numeric
Yes, a zero may show.

 

[Joe4]

I am almost embarrassed to offer this solution, because I know that there has to be a better one (just can't think straight right now), but checking the length of each of those 6 cells should work:

=IF(AND(LEN(I14)>0,LEN(I15)>0,LEN(I16)>0,LEN(I17)>0,LEN(I18)>0,LEN(I19)>0),vlookup(1,W2:Y5,3,false),"")

 

[daniels012]

You got me thinking when you mentioned zero. I then thought about "blanks"
How about:
=if(countblank(I14:I19)=0,vlookup(1,W2:Y5,3,false),"")

Thank You,
Michael

 

[Aladin Akyurek]

I am almost embarrassed to offer this solution, because I know that there has to be a better one (just can't think straight right now), but checking the length of each of those 6 cells should work:

=IF(AND(LEN(I14)>0,LEN(I15)>0,LEN(I16)>0,LEN(I17)>0,LEN(I18)>0,LEN(I19)>0),vlookup(1,W2:Y5,3,false),"")

Maybe...

=IF(COUNTBLANK(I14:I19),"",VLOOKUP(1,W2:Y5,3,0))

 

[T. Valko]

I want to do this formula
=vlookup(1,W2:Y5,3,false)
but only when every cell in I14:I19 are greater than "" (not empty)

How can I do this with a formula?


Thank You,
Michael

Does that mean there might be cells that contain formula blanks in the range I14:I19?

 

[Joe4]

And there it is!

To tell you the truth, I have never used the COUNTBLANK function before, and actually didn't even know that one existed (never really had a need for it).
It certainly comes in handy in these situations.

So, it looks like you asked the question, but I learned something new today!