Prev: File placement with copied sheets
Next: Difference between two date/time values
From: Malcolm on 31 May 2010 12:59
"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,"",COUNTIF(B5:B22,"s")+COUNTIF(H5:H21,"s"))
>
> --
> Gary''s Student - gsnu201003
From: Malcolm on 31 May 2010 13:58
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
> <Malcolm(a)discussions.microsoft.com> 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,"",COUNTIF(B5:B22,"s")+COUNTIF(H5:H21,"s"))
> >>
> >> --
> >> Gary''s Student - gsnu201003
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: File placement with copied sheets
Next: Difference between two date/time values