Prev: Excel 2003 formula
Next: SUMIF Function
From: aganoe on 8 Apr 2010 18:32
Thanks, all three suggestions work!

"Stefi" wrote:

> =SUMPRODUCT(--(A1:A9=B1:B9);--(NOT(ISBLANK(A1:A9))))
>
>
> --
> Regards!
> Stefi
>
>
>
> „aganoe” ezt írta:
>
> > In column A, I have values equal to either YES, NO or NA. In column B, I
> > have values equal to either YES, NO or NA. I want to count the # of cells in
> > column B that equal to their counterpart in column A, but I do not want to
> > count blank cells, ex:
> > A B
> > 1 Yes Yes
> > 2 No No
> > 3 NA No
> > 4
> > 5 Yes Yes
> > 6 Yes Yes
> > 7
> > 8 No No
> > 9 No No
> > Result for B10 should be 6 as I do not want to count row 4 and row 7
> >
> > thanks in advance!
From: Stefi on 9 Apr 2010 06:36
You are welcome! Thanks for the feedback!

Clicking the YES button will be appreciated.

--
Regards!
Stefi



„aganoe” ezt írta:

> Thanks, all three suggestions work!
>
> "Stefi" wrote:
>
> > =SUMPRODUCT(--(A1:A9=B1:B9);--(NOT(ISBLANK(A1:A9))))
> >
> >
> > --
> > Regards!
> > Stefi
> >
> >
> >
> > „aganoe” ezt írta:
> >
> > > In column A, I have values equal to either YES, NO or NA. In column B, I
> > > have values equal to either YES, NO or NA. I want to count the # of cells in
> > > column B that equal to their counterpart in column A, but I do not want to
> > > count blank cells, ex:
> > > A B
> > > 1 Yes Yes
> > > 2 No No
> > > 3 NA No
> > > 4
> > > 5 Yes Yes
> > > 6 Yes Yes
> > > 7
> > > 8 No No
> > > 9 No No
> > > Result for B10 should be 6 as I do not want to count row 4 and row 7
> > >
> > > thanks in advance!
 | 
Pages: 1
Prev: Excel 2003 formula
Next: SUMIF Function