see response in .excel
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"George" <George[ at ]discussions.microsoft.com> wrote in message
news:548F79A8-A48E-451E-969C-547EDB4B9365[ at ]microsoft.com...
[Quoted Text] > 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.)
>
|