Thread: Lose the 0 in the Total cell
View Single Post
  #1  
Old May 31st, 2010, 03:33 PM posted to microsoft.public.excel.worksheet.functions
malcolm
external usenet poster
  
Posts: 106
Default Lose the 0 in the Total cell
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