"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

"Malcolm" wrote:

"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

"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