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
|