Lose the 0 in the Total cell
Gord, Hi,
Thanks big guy, right as usual.
Best Regards,
Malcolm
"Gord Dibben" wrote:
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
.
|