Making formula results not visible in a cell

[mp smith]

In my "total" column I don't want the results of the SUM to show up if there
is not an entry in the cell to the left of the SUM cell.

 

[David Biddulph]

=IF(A101="","",SUM(B1:B100))

 

[T. Valko]

Try something like this:

=IF(A10="","",SUM(.....))