ISBLANK() function
 

Hi.
I need some help.
I have two columns in a sheet, A1:A100 and B1:B100, in which it is:

The first column A1:A100, have some data (numbers). In the second column
apply B1=A1, B2=A2,€¦€¦..B100=A100. In the B101 i am trying to apply the
SUM(B1:B100), but only if the cells A1:A100 are not empty (the zero value
must be considered as number, not empty cell). In the case, which the cells
A1:A100 are empty, i would like to not print anything in B101 cell.
I tried the use of ISBLANK() function
{IF(ISBLANK(B1:B100)=FALSE;SUM(B1:B100);"")}, but when the A1:A100 cells are
empty then the B1:B100 column returns zero values and the SUM(B1:B100)
returns 0 instead to remain empty.

Any idea?
Thank you.

n.n.
(In some cases the cells B1:B100 seem to be empty but it still they value
are 0.)

ISBLANK() function
 

see response in .excel

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"George" wrote in message
...
Hi.
I need some help.
I have two columns in a sheet, A1:A100 and B1:B100, in which it is:

The first column A1:A100, have some data (numbers). In the second column
apply B1=A1, B2=A2,....B100=A100. In the B101 i am trying to apply the
SUM(B1:B100), but only if the cells A1:A100 are not empty (the zero value
must be considered as number, not empty cell). In the case, which the
cells
A1:A100 are empty, i would like to not print anything in B101 cell.
I tried the use of ISBLANK() function
{IF(ISBLANK(B1:B100)=FALSE;SUM(B1:B100);"")}, but when the A1:A100 cells
are
empty then the B1:B100 column returns zero values and the SUM(B1:B100)
returns 0 instead to remain empty.

Any idea?
Thank you.

n.n.
(In some cases the cells B1:B100 seem to be empty but it still they value
are 0.)