I have a column of letters

u
o
u
u
o

The adjacent column also has letters, but it also has blank cells.

u

o
o
u

o

So it looks like something this:

u u
o
uo
u
oo
ou

I want to count the number of non matches. In the above example there
would be two. uo would be a non match as would ou. uu and oo are
matches and o-blank and u-blank are nothing.

I've tried all kinds of count ifs and sum ifs, but I haven't hit on
the right one.

Thanks

On Jun 22, 2:10*pm, "Bob Phillips" <bob.phill...@somewhere.com> wrote:
> Try
>
> =SUMPRODUCT(--(A1:A6<>""),--(B1:B6<>""),--(A1:A6<>B1:B6))

Works perfect, thanks!


>
> --
>
> HTH
>
> Bob
>
> "Blake" <sfc...@gmail.com> wrote in message
>
> news:6ea69861-5914-4637-b40c-(E-Mail Removed)...
>
> >I have a column of letters
>
> > u
> > o
> > u
> > u
> > o
>
> > The adjacent column also has letters, but it also has blank cells.
>
> > u
>
> > o
> > o
> > u
>
> > o
>
> > So it looks like something this:
>
> > u u
> > o
> > uo
> > u
> > oo
> > ou
>
> > I want to count the number of non matches. *In the above example there
> > would be two. *uo would be a non match as would ou. *uu and oo are
> > matches and o-blank and u-blank are nothing.
>
> > I've tried all kinds of count ifs and sum ifs, but I haven't hit on
> > the right one.
>
> > Thanks