# Lose the 0 in the Total cell

M

#### Malcolm

Iâ€™m using the formula below, in a worksheet to count cells containing the
letter S. My problem is in the total cell, it displays a 0 until I enter an S
in the cells it is totaling. Is there a way I can modify the formula so that
it does not display the 0? Iâ€™m using Excel 2007, but the formula must work in
Excel 2003.

=COUNTIF(B5:B22,"s")+COUNTIF(H5:H21,"s")

Thanks,
Malcolm

G

#### Gary''s Student

=IF(COUNTIF(B5:B22,"s")+COUNTIF(H5:H21,"s")=0,"",COUNTIF(B5:B22,"s")+COUNTIF(H5:H21,"s"))

M

#### Malcolm

"Gary''s Student", Hi,
I copied and pasted your solution into the formula bar and all it returned
was the formula itself in the Total cell. I then tried to enter the formula
myself and got the same results. Sorry dude, this didn't work.

Regards,
Malcolm

G

#### Gord Dibben

Your copy and paste changed the format of the cell to Text.

Format to General then F2 and ENTER

Gord Dibben MS Excel MVP

M

#### Malcolm

"Gary''s Student", Hi,
Please forgive me. I am not worthy. I got it to work. You were right and I
am a worm. LOL

Thank you,
Best regards,
Malcolm

M

#### Malcolm

"Gary''s Student", Hi,
I am so sorry. I am not worthy. I kept trying and your solution worked. I
must have been doing something wrong, but you were right and I am a worm. LOL
Thanks dude,

Best regards,
Malcolm

M

#### Malcolm

Gord, Hi,
Thanks big guy, right as usual.

Best Regards,
Malcolm