Lose the 0 in the Total cell
Your copy and paste changed the format of the cell to Text.
Format to General then F2 and ENTER
Gord Dibben MS Excel MVP
On Mon, 31 May 2010 08:15:01 -0700, 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
|