View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
malcolm malcolm is offline
external usenet poster
 
Posts: 57
Default Lose the 0 in the Total cell

Im 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? Im using Excel 2007, but the formula must work in
Excel 2003.

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

Thanks,
Malcolm