I have a spreadsheet in which I enter numbers in, then calculate a
certain range -
sum(f4:f10). The cell that contains this formula always shows 0 if
nothing is entered in this range. How can I edit this forumla that will
display nothing in the cell if nothing is entered, if something is
entered, then it will display the sum

Any suggestions?


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=397250

Hi, Ltat. You have two options.

1) ToolsOptions | View tabuncheck Zero Values in the Window options
section
note that this will affect ALL cells that have a zero value

2) Use an IF formula, as such:

=IF(sum(f4:f10)=0,"",sum(f4:f10))

A blank cell will be displayed if the sum is zero, else the sum will be
displayed.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=397250

swatsp0p Wrote:
Hi, Ltat. You have two options.

1) ToolsOptions | View tabuncheck Zero Values in the Window options
section
note that this will affect ALL cells that have a zero value

2) Use an IF formula, as such:

=IF(sum(f4:f10)=0,"",sum(f4:f10))

A blank cell will be displayed if the sum is zero, else the sum will be
displayed.

HTH

Bruce


Perfect! - Thanx!


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=397250

I am new to pivot tables and have a quandary I can't seem to address. I
have several columns with a code letter representing a theme present in
a large set of qualitative data. So, the row has a comment and then if
the comment fits the designation under a particular theme (column) I
enter the code under that theme to show where it fits. So I'm dealing
with different letters in cells that represent a type of data, under
several columns that represent themes. If the cell is blank, that
means that comment does not fit under that theme. When I try to count
the number of different types of data under the theme columns I can't
get it to tally how many separate codes are listed in each column. so
it looks like this:

Program Inst +
Inst- Course+
Photography Technology I T S
Photography Technology I M P
Photography Technology I C P

It keeps counting blanks and I can't get it to just count the filled
cells - What I'd like is under Inst+ for Photog I there are 1 M, 1T,
1C; under Inst-, 2P; Course+ 1S

Any ideas???


--
lfhale
------------------------------------------------------------------------
lfhale's Profile: http://www.excelforum.com/member.php...o&userid=26457
View this thread: http://www.excelforum.com/showthread...hreadid=397250

Ltat42a Wrote:
Perfect! - Thanx!


Glad it worked for you. Feedback is always appreciated. Which option
did you use?

Cheers!

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=397250

swatsp0p Wrote:
Glad it worked for you. Feedback is always appreciated. Which option
did you use?

Cheers!

Bruce

#1 -
ToolsOptions | View tabuncheck Zero Values in the Window options
section
note that this will affect ALL cells that have a zero value


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=397250