G

#### Guest

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.)