define nonblank in a formula
 

I know how to define a blank space in a formula (i.e. ""). But how do I
define non-blanks?

I want to use a sumproduct formla that would ask to count anything with a
"1" in column A but any value at all in Column B.

Not sure how to symbolize nonblank (any value) for column B.

Thanks

anand

define nonblank in a formula
 

Hi Anand

You could do it like:

--(B2:B1000<"")

or maybe:

--(LEN(B2:B1000)0)

Hope this helps!

Richard


anand wrote:

I know how to define a blank space in a formula (i.e. ""). But how do I
define non-blanks?

I want to use a sumproduct formla that would ask to count anything with a
"1" in column A but any value at all in Column B.

Not sure how to symbolize nonblank (any value) for column B.

Thanks

anand