Blank cell if no value

**Ltat42a** · 08-19-2005, 11:27 AM

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?

**swatsp0p** · 08-19-2005, 11:41 AM

Hi, Ltat. You have two options.

1) Tools>Options | View tab>uncheck 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

**Ltat42a** · 08-19-2005, 11:44 AM

Originally Posted by swatsp0p

Hi, Ltat. You have two options.

1) Tools>Options | View tab>uncheck 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!

**lfhale** · 08-19-2005, 11:46 AM

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???