SPREADSHEET

F

flkulchar

I have a spreadsheet which sums each row across to the
last column...then sums each column down...The sheet
foots and crossfoots.


Question:

If each of the cells is blank, my horizontal crossfoot in
the righthand column displays a ZERO.

Such as:

A1 B1 C1 D1
0
2 4 1 7
2 5 2 9

I WISH THE D1 CELL TO NOT DISPLAY 0;

I WISH IT TO APPEAR BLANK.

Please help,

Larry
 
C

CLR

Wrap your formula in an IF statement............

=IF(yourformula=0,"",yourformula)

Vaya con Dios,
Chuck, CABGx3
 
F

Frank Kabel

Hi
do you want to prevent all zeros (e.g. generated by summing +1 and -1)
or only the zero for blank cells. For the latter use:
=IF(COUNT(A1:C1),SUM(A1:C1),"")
 
Top