View Single Post
  #6  
Old May 31st, 2010, 05:59 PM posted to microsoft.public.excel.worksheet.functions
malcolm
external usenet poster
 
Posts: 106
Default Lose the 0 in the Total cell

"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

"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu201003